Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What to set in order to select UTF8 character set in sqlplus?

465942Nov 9 2005 — edited Nov 18 2005

We are using 9.0.1.
select * from nls_database_parameters;
NLS_CHARACTERSET = UTF8
LANGUAGE = AMERICAN
TERRITORY = AMERICA

Web page encoding is UTF8.
We can see traditional and simplied chinese characters on web page without problem.

When we want to select thru sqlplus, the problem comes.
At first, I set the default win2000 language to traditional chinese.
locales is Chinese (Hong Kong).
Ansi Code page becomes 950. reboot the machine
set NLS_LANG=TRADITIONAL CHINESE.HONG KONG=ZHT16MSWIN950 in registry

web page can show traditonal and simplied chinese characters, but sqlplus fails.

Then I set the default win2000 language to simplied chinese, set the locales
to Chinese (PRC). reboot the machine
set NLS_LANG to simplied chinese character set.

web page can show traditonal and simplied chinese characters, but sqlplus still fails.

I have even set the NLS_LANG to _.UTF8. sqlplus still cannot show proper character set. Only the web page is okay.

I have referenced Oracle globalization web pages. I follow everything. What should I try?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2005

Added on Nov 9 2005

#database-key-features, #globalization-support

8 comments

31,532 views