Master mysql Some Chinese characters in the table are changed to?

1

percona-toolkit edition2.2.7-1
command
pt-table-checksum --nocheck-replication-filters --no-check-binlog-format --replicate=darabase.checksums --create-replicate-table --databases= h=masterip,u=,p=,P=3306
pt-table-sync --replicate=database.checksums h=masterip,u=,p= h=slave,u=xywyr,p= --execute
then master mysql Some Chinese characters in the table are changed to??? .
Can I fix the garbled code?
mysql edition 5.7.35

1 Like
2

pt-table-sync defaults to utf8 character set. If you need to use a Chinese-specific character set, you can specify this with --charset

2 Likes
3

What character set should be used in Chinese? --charset=
The coding rule of the database is utf8mb4

pt-table-sync --replica=database. Checksums h=masterip, u=, p=h=slave, u=xywyr, p=-- execute This command will modify the data of the master database. I do not want to modify the data of the master database，
What should I do?

1 Like