Re: Character Set Problems

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 15 Jun 2007 07:58:31 GMT
Message-ID: <1181894307.513579@proxy.dienste.wien.at>

Paul <paulwragg2323_at_hotmail.com> wrote:
> Apparently (the retreiving application is the customers, not ours), it
> expects UTF8 data.

If that were true, the program would not choke on the UTF8 sequence that comes out of the database or display it as two characters, right?

> 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.

That should make no difference.
But during an upgrade (did you upgrade the client as well?) frequently things get changed (you adjust settings in the OS, ...) that may have an influence.

You will be able to handle this problem best if you understand how Oracle handles character conversion.
Is is clear to you why you always get the UTF-8 sequence as two characters, no matter how you set NLS_LANG?

Yours,
Laurenz Albe Received on Fri Jun 15 2007 - 02:58:31 CDT