从源库进行数据同步时发现目标库插入的中文数据乱码
解决方式:修改canal-adapter 中conf 下application.yml文件
设置字符集:characterEncoding=utf-8
canalAdapters:
- instance: example # canal instance Name or mq topic name
groups:
- groupId: g1
outerAdapters:
- name: logger
- name: rdb
key: mysql1
properties:
jdbc.driverClassName: com.mysql.jdbc.Driver
jdbc.url: jdbc:mysql://127.0.0.1:3306/mytest2?useUnicode=true&characterEncoding=utf-8
jdbc.username: canal
jdbc.password: canal