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

「爱情、让人受尽委屈。」 2023-06-13 06:14 48阅读 0赞

打开PL/SQL 弹出如下提示：

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\.

**原因**：这是 **Oracle数据库**的字符集编码 和 **PL/SQL Oracle客户端**的字符集编码不一致引起的。

**解决方法**：  
先查看oracle数据库的字符集编码，如下所示：

select * from nls_database_parameters where parameter in ('NLS_LANGUAGE', 'NLS_TERRITORY','NLS_CHARACTERSET');

查询结果如下：  
![在这里插入图片描述][20191114154330496.png]  
查看环境变量的NLS\_LANG，如下所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpc2hrMzE0_size_16_color_FFFFFF_t_70]  
将 SIMPLIFIED CHINESE\_CHINA.**AL32UTF8** 修改为 SIMPLIFIED CHINESE\_CHINA.**ZHS16GBK**

**另可参考**：https://blog.csdn.net/liuhailiuhai12/article/details/70474159

[20191114154330496.png]: https://img-blog.csdnimg.cn/20191114154330496.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpc2hrMzE0_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2019111415455292.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpc2hrMzE0,size_16,color_FFFFFF,t_70