启动PL/SQL Developer 报字符编码不一致错误

最新推荐文章于 2023-06-09 20:31:39 发布

原创最新推荐文章于 2023-06-09 20:31:39 发布 · 119 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

oracle 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了当数据库字符集AL32UTF8与客户端字符集ZHS16GBK不一致时可能引发的问题，并提供了解决方案。建议通过修改注册表中的NLS_LANG键值来统一字符集设置。

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。

[img]http://dl.iteye.com/upload/attachment/511968/e361ada0-81fa-3b13-81f7-034af5d6a343.png[/img]

找到到文中提示的路径，发现NLS_LANG键的值为:

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

修改为：SIMPLIFIED CHINESE_CHINA.AL32UTF8即可.

[img]http://dl.iteye.com/upload/attachment/511972/5d603faa-2755-385d-97de-81ef38d8784c.jpg[/img]