启动PL/SQL Developer 报字符编码不一致错误 ,Database character set (AL32UTF8)
程序员文章站
2022-04-09 10:53:39
...
Database character set (ZHS16GBK) and Client character set (AL32UTF8) 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\HOME0.
打开注册表,通过命令regedit。找到到文中提示的路径,发现 NLS_LANG 键的值为:
ZHS16GBKSIMPLIFIED CHINESE_CHINA.AL32UTF8
修改为:SIMPLIFIED CHINESE_CHINA.
如果以上都还没有解决问题,那么就 修改环境变量里面的 NLS_LANG 的值,和服务器一样
保证这两个地方 和服务器的 编码一致就 OK
啊啊啊啊,,,,,,这个问题...浪费了我 一两个小时....希望你们别走我的老路了.....