# Pt-archiver 的 --charset 字符集不生效，中文乱码问题

**URL:** <https://forums.percona.com/t/pt-archiver-charset/16066>\
**Category:** Uncategorized\
**Tags:** percona\
**Created:** [June 10, 2022, 3:32am UTC](https://forums.percona.com/t/pt-archiver-charset/16066 "2022-06-10T03:32:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vante](https://avatars.discourse-cdn.com/v4/letter/v/a88e4f/32.png) [@vante](https://forums.percona.com/u/vante)\
**Post date:** [June 10, 2022, 3:32am UTC](https://forums.percona.com/t/pt-archiver-charset/16066/1 "2022-06-10T03:32:51Z")

</div>

命令：  
/opt/soft/percona-toolkit-2.2.14/bin/pt-archiver --source h=xxxxxxxx,P=xxxxxx,u=xxxxxx,p=xxxxxxxx,D=xxxxxx,t=xxxxxxx,A=utf8 --dest h=xxxxxx,P=xxxxxx,u=xxxx,p=xxxxxxxxx,D=xxxxxxxxx,t=xxxxxxxxxx,A=utf8 --where=“note=‘语音播报’” --progress=1000 --sleep=1 --limit=1000 --txn-size=1000 --set-vars lock\_wait\_timeout=5 --why-quit --statistics --purge --bulk-delete  
执行查看全日志，中文没有乱码

命令：  
/opt/soft/percona-toolkit-2.2.14/bin/pt-archiver --source h=xxxxxxx,P=xxxxx,u=xxxxxx,p=xxxxxxx,D=xxxxxx,t=xxxxx,A=utf8 --dest h=xxxxxxx,P=xxxxxx,u=xxxx,p=xxxxxxx,D=xxxxxx,t=xxxxxxx,A=utf8 --where=“SCHEMA\_NAME =‘语音播报’ and statTime \< DATE\_SUB(NOW(),INTERVAL 1 MONTH)” --progress=1000 --sleep=1 --limit=1000 --txn-size=1000 --set-vars lock\_wait\_timeout=5 --why-quit --statistics --bulk-delete  
查看全日志，中文乱码

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/33fdb8212d6c5e2de4c6f8663be067b2316d9e47.png)

命令中添加 --charset 仍然乱码  
表字符集为utf8  
percona版本为2.2.14