sqlplus 在出错的中文部分是乱码,如何解决?
今天教大家处理这个问题,同理可用于 plsql等其他客户端,原理都一样
select userenv('language') from dual;
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
SIMPLIFIED CHINESE_CHINA.AL32UTF8
SQL> select *from v$nls_parameters;
PARAMETER VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CHARACTERSET AL32UTF8
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CHARACTERSET AL32UTF8
确定上面三个值的组合是和第一个查询一样
然后客户端设置NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
如我的oracle的环境变量.bash_profile添加一行到底部
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"