首页 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"

更新时间: 2022-01-19 15:33:31

问题描述

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