oracle 中文乱码
select * from nls_database_parameters 显示nls_lanaguage是AMERICA
select * from nls_instance_parameters 显示也是AMERICA
select * from nls_session_parameters 显示是SIMPLIFIED CHINESE
客户端注册表中的nls_lang 值是 SIMPLIFIED CHINESE_CHINA.ZHS16GBK
请问要怎么改?
select * from nls_database_parameters 显示nls_lanaguage是AMERICA
select * from nls_instance_parameters 显示也是AMERICA
select * from nls_session_parameters 显示是SIMPLIFIED CHINESE
客户端注册表中的nls_lang 值是 SIMPLIFIED CHINESE_CHINA.ZHS16GBK
请问要怎么改?
http://oracle.chinaitlab.com/induction/37776.html
在注册表中查找NLS_LANG:
改成
AMERICAN_AMERICA.US7SCII
或
AMERICAN_AMERICA.ZHS16GBK
或别的.后面的那个是什么要查看服务器, 用
SELECT * FROM V$NLS_PARAMETERS;
nls_lang=SIMPLIFIED CHINESE_CHINA.US7ASCII