PL/SQL 字符集不匹配警告处理

Jun 23, 2017 阅读(212)

标签: PLSQL

数据库字符集(AL32UTF8)和客户端字符集(ZHS16GBK)不一致

PL/SQL登录后提示:

Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.

Character set conversion may cause unexpected results.


Note: you can set the client character set through the NLS_LANG environment variable or the NLS_LANG registry key in

HKEY_LOCAL_MACHINE\.


方式一:修改 NLS_LANG 环境变量

SIMPLIFIED CHINESE.ZHS16GBK 改为 SIMPLIFIED CHINESE_CHINA.AL32UTF8

blob.png


方式二:修改注册表中 NLS_LANG 的值

打开注册表:开始 >> 运行 >> 输入"regedit"确定 

进入到 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDB12Home1下

将 NLS_LANG 的值 SIMPLIFIED CHINESE.ZHS16GBK 改为 SIMPLIFIED CHINESE_CHINA.AL32UTF8

注册表修改oracle 配置


最后重启PL/SQL登录的时候就看不到那烦人的警告提示。