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_OraClient11g_home2.
在安装PLSQLdeveloper的主机上安装oracle实例,下载一个orcale的instantclient_11_2包,复制安装的oracel的tnsnames.ora到里面,修改Host为oracel所在主机的IP;
修改系统变量path,添加instantclient_11_2的位置,新建NLS_LANG值为:SIMPLIFIED CHINESE_CHINA.AL32UTF8
修改注册表:
打开注册表,‘开始’-‘运行’ 输入‘regedit’-确定。
找到提示中给出的路径,
找到 NLS_LANG 键,他的值原来是:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
修改为:SIMPLIFIED CHINESE_CHINA.AL32UTF8
重新打开plsql ,登录,好了。