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

**URL:** <https://forums.percona.com/t/master-mysql-some-chinese-characters-in-the-table-are-changed-to/18576>\
**Category:** Uncategorized\
**Created:** [November 16, 2022, 2:54am UTC](https://forums.percona.com/t/master-mysql-some-chinese-characters-in-the-table-are-changed-to/18576 "2022-11-16T02:54:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tony1](https://avatars.discourse-cdn.com/v4/letter/t/858c86/32.png) [@tony1](https://forums.percona.com/u/tony1)\
**Post date:** [November 16, 2022, 2:54am UTC](https://forums.percona.com/t/master-mysql-some-chinese-characters-in-the-table-are-changed-to/18576/1 "2022-11-16T02:54:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [November 16, 2022, 3:49pm UTC](https://forums.percona.com/t/master-mysql-some-chinese-characters-in-the-table-are-changed-to/18576/2 "2022-11-16T15:49:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tony1](https://avatars.discourse-cdn.com/v4/letter/t/858c86/32.png) [@tony1](https://forums.percona.com/u/tony1)\
**Post date:** [November 17, 2022, 5:07am UTC](https://forums.percona.com/t/master-mysql-some-chinese-characters-in-the-table-are-changed-to/18576/3 "2022-11-17T05:07:14Z")

</div>

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?