Linux下配置 NLS_LANG 解决sqlplus乱码

最新推荐文章于 2021-05-08 00:12:35 发布

cswttov537085

最新推荐文章于 2021-05-08 00:12:35 发布

阅读量440

点赞数

文章标签：操作系统数据库

有时候登陆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博客 ” ，链接：http://blog.itpub.net/28538954/viewspace-1255386/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28538954/viewspace-1255386/