Language problem
Hi all,
I am having some japanese datas in my oracle database. If i select those datas i got the following output.
SQL> SELECT LNAME FROM TEMP;
LNAME
--------------------------------------------------------------------------------
???
???
???
Then i gave the following command
SQL> alter session set nls_language = 'JAPANESE';
Session altered.
SQL> alter session set nls_territory = 'JAPAN';
Session altered.
Even now i am not able to see the japanese characters.
my database characterset is utf8.
What will be the problem. Please suggest something to overcome this problem. And for your info i can able to see the japanese character in the japanses Operating system. But my os is English.
bye
Nathan