Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Character Set Problems
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