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，导入后乱码消失。

　　

转载于:https://www.cnblogs.com/Babylon/p/9233467.html