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
希望对你有帮助.谢谢.