Skip to Main Content

Chinese

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!

sqlplus中文乱码 toad正常 secureCRT也乱码(已设置UTF8)

iimaxOct 19 2012 — edited Oct 20 2012
环境 CentOS5.8 ORACLE 11g R2
NLS设置:
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

测试表:
SQL> desc dept;
Name Null? Type
----------------------------------------- -------- ----------------------------
DEPT_ID NOT NULL NUMBER(4)
DEPT_NAME NOT NULL NVARCHAR2(30)
DEPT_MAIL VARCHAR2(30)
CREATE_DATE DATE
CREATOR VARCHAR2(30)
STATUS NUMBER(38)

在toad里 INSERT UPDATE 一切正常。客户端sqlplus 以及secureCRT连服务器 都是乱码

DEPT_NAME
------------------------------
??????
????
请问要怎样设置? 网上有搜到 sqlplus不支持unicode字符,但是不太明白
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2012
Added on Oct 19 2012
5 comments
3,119 views