Skip to Main Content

Oracle Database Discussions

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!

Implementing Chinese language in Oracle 11g

AbkFeb 10 2009 — edited Mar 13 2009
Hi,

I had implemented Chinese language (along with the default English) in oracle 8i (Version 8.1.7) database with Character set = UTF8 and NLS_LANG=AMERICAN_AMERICA.UTF8.I am able to insert chinese as well as English characters through Forms 6i(Client side) into the above 8i database(server side).

I created Oracle 11g(Release 1) database with following configurations :
character set=AL32UTF8
NLS_LANG=AMERICAN_AMERICA.AL32UTF8 (in Registry)

But, when i try to insert the Chinese characters, Then i can see only the symbol '??????????' gets reflected from the database.

ALTER SESSION SET NLS_LANGUAGE="SIMPLIFIED CHINESE" NLS_TERRITORY=CHINA;

Also i tried the above command, but I end up only with ??????? instead of Chinese characters in SQL prompt.

Kindly provide the configurations needed to be made(both in the Client & Server side) to implement Chinese language (along with the default English) in Oracle 11g(Release 1) database.

With Regards,
Abul and srini
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2009
Added on Feb 10 2009
5 comments
1,778 views