Re: Character Set Problems

From: <matthias.hoys_at_gmail.com>
Date: Fri, 15 Jun 2007 00:54:10 -0700
Message-ID: <1181894050.279354.237790@m36g2000hse.googlegroups.com>

On Jun 14, 3:47 pm, Paul <paulwragg2..._at_hotmail.com> wrote:
> Hi Laurenz,
>
> Apparently (the retreiving application is the customers, not ours), it
> expects UTF8 data.
>
> I don't know if this is relevant but apparently the process has been
> working fine for over a year until they upgraded from Oracle 8 to
> Oracle 9. Nothing else has been changed. I am trying to get this
> confirmed as I cannot see why the Oracle upgrade would have made any
> difference.
>
> Thanks for the input!
>
> Paul

Did they also upgrade the Oracle client environment ? How did you set the client NLS_LANG settings (WE8ISO8859P1) ? Did you let Oracle do it during the installation of the client software, or did you manually change it in the registry (which is often incorrect). The client NLS_LANG settings should match the *Windows* character set settings and not those of the Oracle database server. They could be the same, but often they are not.

Matthias Received on Fri Jun 15 2007 - 02:54:10 CDT