Skip to Main Content

SQL & PL/SQL

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!

display chinese characters in sqlplus ( unix )

551174Oct 1 2007 — edited Oct 2 2007
I am using sqlplus in unix...
I want to insert a few chinese characters in a table and should be able to retrieve it in sqlplus...

In unnix, I tried to set the NLS_LANG=_.UTF8
and LC_ALL=UTF-8

and in sqlplus
and alter session set NLS_LANGUAGE='SIMPLIFIED CHINESE';
alter session set NLS_TERRITORY=China;

But i am not able to see the chinese characters on the sqlplus screen to insert into the table ?

Any help is appreciated...thanks...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 30 2007
Added on Oct 1 2007
7 comments
2,795 views