1.打开注册表-regedit
2.找到如下目录:
HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> KEY_OraDb10g_home1
3.执行sql :select userenv('language') from dual; 获取oracle服务端字符集X
3. 右键修改 NLS_LANG 值为 X 即可。
备注:oracle10g UTF8编码:AMERICAN_AMERICA.AL32UTF8
GBK编码:SIMPLIFIED CHINESE_CHINA.ZHS16GBK