I installed my oracle 9i with characterset WE8MSWIN1252, and national character set AL16UTF16, nls_language="TRADITIONAL CHINESE" and nls_territory="HONG KONG" on windows 2000 server. I have also changed environment variable nls_lang=TRADITIONAL CHINESE_HONG KONG.WE8MSWIN1252
After starting up oracle database i can see that my initialization parameters have been assigned correctly. But when I am issuing the following command
select userenv('LANGUAGE') FROM DUAL;
The result is AMERICA_AMERICA.WE8MSWIN1252, which is wrong instead of TRADITIONAL CHINESE_HONG KONG.WE8MSWIN1252. After connection to oracle database through the SQL Plus, I can show parameter correctly as I have assigned.
Even I tried to change CHARACTER SET TO AL32UTF8 BY APPLYING
ALTER DATABASE GLOBORA CHARACTER SET AL32UTF8
it gives error though.
I would appreciate if anyone can come forward to provide solution.