sqlldr加载字符问题
CTL文件
load data CHARACTERSET UTF-8 infile "F:\dmp\sqlldr\t_user.txt" append into table T_USER fields terminated by '|' trailing nullcols ( ID, NAME, AGE )
sqlldr admin/000000@172.16.49.11:1522/orcl control=load.ctl log=log.log bad=bad.log errors=5000 rows=1000 bindsize=10485760
加载后t_user乱码
select * from nls_database_parameters;--或者 select userenv('language') from dual;
将CTL中换成数据库的字符ZHS16GBK,导入后乱码消失。