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

Bug #1504497 reported by MrZhang on 2015-10-09
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to

Bug Description

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 '?????';


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?

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

Changed in percona-toolkit:
status: New → Incomplete
Launchpad Janitor (janitor) wrote :

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

Changed in percona-toolkit:
status: Incomplete → Expired
responder (responder-s) wrote :

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.

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers