sqlldr load UTF8 error
Error load utf8
2023-09-27 14:25:24 时间
The default length semantics for all datafiles (except UFT-16) is byte. So in your case you have a CHAR of 3500 bytes rather than characters. You have some multi-byte characters in your file and the 2624 characters is therefore using more than 3500 bytes, hence the (misleading) message.
You can sort this out by using character length semantics instead
alter this line in your control file
characterset UTF8
to this
characterset UTF8 length semantics char
and it will work on characters for CHAR fields (and some others) - in the same way that you have set up your table, so 3500 characters of up to four bytes each.
相关文章
- ERROR executor.CoarseGrainedExecutorBackend: RECEIVED SIGNAL TERM
- jboss final 7.1.1相关error以及解决方式
- Linux有问必答:如何修复“sshd error: could not load host key”
- docker 运行后端项目出错,查看日志,错误信息为:Error: Unable to access jarfile /xxx/xxx.jar
- ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL,or READS SQL DATA in its declaration and binary logging is enabled
- HTTP 错误 500.21 - Internal Server Error 处理程序“ExtensionlessUrlHandler-ISAPI-4.0_64bit”在其模块列表中有一个错误模块“IsapiModule” 解决方法
- UVaLive 5009 Error Curves (三分)
- flink error Hadoop is not in the classpath/dependencies.
- 转 ERROR: Error in Log_event::read_log_event()
- vmware虚拟机ubuntu编译fatal error: Killed signal terminated program cc1plus
- 安装wsl的必备操作——开启CPU虚拟化——WslRegisterDistribution failed with error_ 0x8007019e 0x800701b 0x80370102 请启用虚拟机平台
- odoo13 Error Js “Could not find client action”
- ORA-00600: internal error code, arguments: [4194], [53], [41], [], [], [], [], []
- 立创EDA 导出元件到 AD打开原理图出现“load file error:undefined object binary code 0”然后是空白,解決方法
- 解决浏览器console控制台报错 : Failed to load resource: net::ERR_SSL_PROTOCOL_ERROR(SSL协议错误)