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

打开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');

查询结果如下：

查看环境变量的NLS_LANG，如下所示：

将 SIMPLIFIED CHINESE_CHINA.AL32UTF8 修改为 SIMPLIFIED CHINESE_CHINA.ZHS16GBK

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