4.0.3 mysql 通过CREATE JOB 同步数据之后中文变成了?

Question

创建任务配置如下
FROM MYSQL('include_tables'='t_architecture','password'='123123','database'='organ_platform','driver_class'='com.mysql.cj.jdbc.Driver','offset'='initial','driver_url'='mysql-connector-java-8.0.25.jar','jdbc_url'='jdbc:mysql://127.0.0.1:3306/organ_platform?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&connectionCollation=utf8mb4_unicode_ci&useSSL=false&serverTimezone=Asia/Shanghai','user'='root' ) TO DATABSE organ_platform ('table.create.properties.replication_num'='1')
同步之后数据中文都变异常了

徐振超@SelectDB(可以直接加微信Faith_xzc) · Accepted Answer

编码问题，试一下这个

CREATE JOB multi_table_sync
ON STREAMING
FROM MYSQL (
    "jdbc_url" = "jdbc:mysql://127.0.0.1:3306/organ_platform?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull",
    "driver_url" = "mysql-connector-java-8.0.25.jar",
    "driver_class" = "com.mysql.cj.jdbc.Driver",
    "user" = "root",
    "password" = "123123",
    "database" = "organ_platform",
    "include_tables" = "t_architecture",
    "offset" = "initial"
)
TO DATABASE organ_platform (
    "table.create.properties.replication_num" = "1"
)

z38822432 · Answer

4.0.3 mysql 通过CREATE JOB 同步数据之后中文变成了?

2 Answers