sqlldr导入数据中文乱码
- 之前ctl文件定义
点击(此处)折叠或打开
- LOAD DATA
- CHARACTERSET ZHS16GBK
- INFILE 'wxls.csv'
- APPEND
- INTO TABLE temp_import20171201
- FIELDS TERMINATED BY ","
- TRAILING NULLCOLS
- (TEL,
- RESELLER,
- PAPERS_NO,
- PRODUCT_NAME,
- TICKET_PRICE,
- CONSUME_TIME DATE "YYYY-MM-DD HH24:mi:ss",
- ORDER_NO
- )
导入数据
点击(此处)折叠或打开
- sqlldr userid=test/test control=import.ctl log=import.log bad=bad.log
结果显示有中文全部乱码
修改ctl文件
点击(此处)折叠或打开
- LOAD DATA
- CHARACTERSET ZHS16GBK
- INFILE 'wxls.csv'
- APPEND
- INTO TABLE temp_import20171201
- FIELDS TERMINATED BY ","
- TRAILING NULLCOLS
- (TEL,
- RESELLER,
- PAPERS_NO,
- PRODUCT_NAME,
- TICKET_PRICE,
- CONSUME_TIME DATE "YYYY-MM-DD HH24:mi:ss",
- ORDER_NO
- )
点击(此处)折叠或打开
- sql>delete from temp_import20171201
导入后查询，结果正常，切忌在windows 下编辑的文件在linux下一定要dos2uninx一下
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24486203/viewspace-2148158/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
