Implementing Chinese language in Oracle 11g
AbkFeb 10 2009 — edited Mar 13 2009Hi,
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