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 公共云