PL/SQL Database character set (WE8ISO8859P1) and Client character set (UTF8) are different

71 阅读1分钟

Database character set (WE8ISO8859P1) and Client character set (UTF8) 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_OraClient10g_home2.

 

最近才碰到的问题:

我在这样处理的:

在 在注册表下:修改:NLS_LANG

 

第二步:修改内容是关键:

把原来的 SIMPLIFIED CHINESE_CHINA.UTF8 修改成: AMERICAN_AMERICA.WE8ISO8859P1

这样就有服务器的character一样了. 如果你是其它character,可以在网上找到相应的完整3代码的:如:AMERICAN_AMERICA.WE8ISO8859P1

 

希望对你有帮助.谢谢.