sqlplus登陆oracle服务器查询表显示中文是?乱码
SQL> select * from test11;
ID
----------
NAME
--------------------------------------------------------------------------------
111
??
222
??
333
??????
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
[oracle@fx ~]$ export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
SQL> insert into test11 values(334,'张东');
1 row created.
SQL> select * from test11;
ID NAME
---------- --------------------
334 张东
111 肖明
222 吴明
333
SQL> insert into test11 values(335,'吴敏');
1 row created.
SQL> select * from test11;
ID NAME
---------- --------------------
334 张东
335 吴敏
111 肖明
222 吴明
333
本文转自 xxl714 51CTO博客,原文链接:http://blog.51cto.com/dreamgirl1314/1649427,如需转载请自行联系原作者