导出脚本中增加:
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
或者vi ~/.bash_profile增加:
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
source ~/.bash_profile #生效环境
数据库字符集
SELECT DISTINCT (NLS_CHARSET_NAME(CHARSETID)) CHARACTERSET,DECODE(TYPE#,1,DECODE(CHARSETFORM,1,'VARCHAR2',2,'NVARCHAR2','UNKOWN'),9,DECODE(CHARSETFORM,1,'VARCHAR',2,'NCHARVARYING','UNKOWN'),96,DECODE(CHARSETFORM, 1, 'CHAR', 2, 'NCHAR', 'UNKOWN'),112,DECODE(CHARSETFORM, 1, 'CLOB', 2, 'NCLOB', 'UNKOWN')) TYPES_USED_IN FROM SYS.COL$ WHERE CHARSETFORM IN (1, 2) AND TYPE# IN (1, 9, 96, 112);
select * from nls_database_parameters;
select * from v$nls_parameters;