Dataphin集成任务同步失败报错:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '??_?????,RegTime from co_base1 where (DATE_FORMAT(RegTime,'%Y%m%d') <'20220112')' at line 1"
问题描述
Dataphin集成任务同步失败报错:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '??_?????,RegTime from co_base1 where (DATE_FORMAT(RegTime,'%Y%m%d') <'20220112')' at line 1"。
问题原因
数据源jdbc配置使用UTF8字符集。
解决方案
修改数据源的JDBC配置,添加useUnicode=true&characterEncoding=utf8即可。
适用于
- Dataphin 公共云