Re: One question about UTF8

From: Matthias Hoys <anti_at_spam.com>
Date: Tue, 17 Jan 2006 20:31:40 +0100
Message-ID: <43cd461d$0$3802$ba620e4c@news.skynet.be>

"lsllcm" <lsllcm_at_gmail.com> wrote in message news:1137484596.482437.12060_at_o13g2000cwo.googlegroups.com...
>I have one question about UTF8, I have one db 9207 windows with UTF8
> charset.
>
> We have used jsp page to insert one record with chinese word to table,
> then I try to use sqlplus client to retrieve the record.
>
> When I set the environment variable by using "set
> NLS_LANG=AMERICAN_AMERICA.UTF8", it display incorrect chars,
>
> When I set the environment variable by using "set
> NLS_LANG=AMERICAN_AMERICA.ZHS16CGB231280", it display correct chars,
>
> Can anyone explain it for us?
>
> Thanks
> Jacky
>

If the NLS_LANG settings on the client are identical than those on the server, no conversions are being done. You should always set your NLS_LANG parameter on the client to the correct value for your codepage on the client, this could be the same or different than the server settings.

To be short : just install the Oracle client software and don't change NLS_LANG :-) Received on Tue Jan 17 2006 - 13:31:40 CST