首页 > 代码库 > PL/SQL错误提示 database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
PL/SQL错误提示 database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
这是由于安装oracle客户端的时候没有设置对字符集造成的,没啥大问题,不影响使用,但是还是收拾好了比较爽一些。解决方法很简单。
启动PL/SQL Developer 报字符编码不一致错误
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\SOFTWARE\ORACLE\KEY_Oracle_10g.
打开注册表,
开始--运行--输入regedit--回车。
依次打开节点 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_Oracle_10g
右键点NLS_LANG,点击修改,将键值:
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
修改为:SIMPLIFIED CHINESE_CHINA.AL32UTF8即可。
重启你的plsql。没有错误了吧。
PL/SQL错误提示 database character set(AL32UTF8) and Client character set(ZHS16GBK) are different