建立兩個本地環境變量:
lang=zh_cn.gbk
nls_lang=simplified chinese_china.zhs16gbk
注:
oracle的字元集:
select * from v$nls_parameters;
1 nls_language simplified
chinese
2 nls_territory china
3 nls_currency ¥
4 nls_iso_currency china
5 nls_numeric_characters .,
6 nls_calendar gregorian
7 nls_date_format dd-mon-rr
8 nls_date_language simplified
9 nls_characterset al32utf8
即:
系統環境變量 nls_lang 設定為: nls_lang = language_territory.charset