查询服务器的字符集设置:
select * from nls_database_parameters
Windows客户端字符集设置:
//key_local_machine/software/oracle/homeo/nls_lang 该键值下可设置以下值
AMERICAN_AMERICA.US7ASCII
AMERICAN_AMERICA.WE8ISO8859P1
AMERICAN_AMERICA.WE8MSWIN1252
TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950
TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
American_america.utf8
注:客户端的字符集与服务器端的字符集最好一致,以免产生字符集转换问题