pt-online-schema-change utf8 chinese comments be messy

[MrZhang]

Mysql version: 5.1
percona tookit version:2.2.1
Command:./pt-online-schema-change --alter "add index scid (scid)" D=baidutui,t=goods_scid -u root -p ***** --execute

My table use utf8 utf8_general_ci and with chinese comments.
When I use pt-online-schema-change to add index , everything goes well and then success terminated.
But I saw the chinese comments become '?????';

[Nilnandan Joshi (nilnandan-joshi)]

Hi,

It seems, you are using old version. Can you please try with latest version of Percona Tollkit 2.2.15 and let us know if you still face this issue?

https://www.percona.com/downloads/percona-toolkit/

If yes, then please provide table structure, PTDEBUG=1 output of that command and test case if possible.

[Launchpad Janitor (janitor)]

[Expired for Percona Toolkit because there has been no activity for 60 days.]

[responder (responder-s)]

To whom it may concern, I encountered the same issue today (on 2.2.16-1).

Thanks to PTDEBUG=1 trace, I found the issue came from the default mysql client charset is latin1.

After added 'default-character-set=utf8' into my.cnf [client] section, the problem solved! : )

Didn't tested, but --charset or A=utf8 should do the magic, too.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1309