在查ORACLE数据库时返回的中文记录是乱码。下面是WIN和LIUNX客户端字符集的区别。
SecureCRT下查询
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
cmd or PL/SQL 下查询
SQL> select USERENV('LANGUAGE') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
修改办法
"cd ~":进入Liunx用户的当前目录 vi .bash_profile文件加入下面变量
NLS_LANG="SIMPLIFIED CHINESE_CHINA".ZHS16GBK
export NLS_LANG
退出保存后。source .bash_profile
SecureCRT下查询
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
cmd or PL/SQL 下查询
SQL> select USERENV('LANGUAGE') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
修改办法
"cd ~":进入Liunx用户的当前目录 vi .bash_profile文件加入下面变量
NLS_LANG="SIMPLIFIED CHINESE_CHINA".ZHS16GBK
export NLS_LANG
退出保存后。source .bash_profile