有时候登陆linux的sqlplus时显示中文乱码:
-
[oracle@sj-db1 ~]$ sqlplus / as sysdba
-
-
SQL*Plus: Release 11.2.0.1.0 Production on ?????? 8?? 21 15:36:01 2014
-
-
Copyright (c) 1982, 2009, Oracle. All rights reserved.
-
-
-
????:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
-
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-
-
SQL> exit
-
?? Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
-
With the Partitioning, OLAP, Data Mining and Real Application Testing options ???
这时候需要对NLS_LANG 进行配置来解决
-
[oracle@sj-db1 ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
-
[oracle@sj-db1 ~]$ sqlplus / as sysdba
-
-
SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 21 15:36:10 2014
-
-
Copyright (c) 1982, 2009, Oracle. All rights reserved.
-
-
-
Connected to:
-
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
-
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-
-
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28538954/viewspace-1255386/
,如需转载,请注明出处,否则将追究法律责任。