oracle的字符集选择哪个,oracle字符集问题 — oracle-tech

问题：维语或藏语在plssql中显示正常，在sqlplus中显示乱码，但是插入然后选择时也会乱码，请问该怎么解决，思路是什么？

plssql测试如下

SQL> select ykk044 from kk19 where ykk044 is not null

2 /

YKK044

--------------------------------------------------------------------------------

ئالىمجان ئابدۇرېشىت

SQL> insert into kk19 (ykk099,aac001,aac002,ykk044) values('22','ddd','ddd','ئالىمجان ئابدۇرېشىت'

2 );

1 row inserted

SQL> select ykk044 from kk19 where ykk044 is not null

2 /

YKK044

--------------------------------------------------------------------------------

???????? ??????????

ئالىمجان ئابدۇرېشىت

sqlplus测试如下

SQL> select ykk044 from kk19 where ykk044 is not null ;

YKK044

--------------------------------------------------------------------------------

？？？？？？？？ ？？？？？？？？？？ ----乱码

SQL> insert into kk19 (ykk099,aac001,aac002,ykk044) values('232','ddd','ddd','

الىمجان ئابدۇرېشىت'

2 );

1 row created.

SQL> select ykk044 from kk19 where ykk044 is not null ;

YKK044

-------------------------------------------------------------------------------

???????? ??????????

？？？？？？？？ ？？？？？？？？？？ --都是乱码

查看服务器字符集

SQL> select userenv('language') from dual ;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.ZHS16GBK

客户端字符集也是AMERICAN_AMERICA.ZHS16GBK

SQL> host set nls_lang=AMERICAN_AMERICA.ZHS16GBK

请问怎么做才能插入显示正常？为什么plssql与sqlplus显示的不一样，同一行一个正常，一个乱码？