Bug #47696 Syntax Error On Slave When Using Special Characters With utf8
Submitted: 29 Sep 2009 5:58 Modified: 7 Nov 2015 8:20
Reporter: Mikiya Okuno Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.0.77 OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[29 Sep 2009 5:58] Mikiya Okuno
Replication stops due to syntax error on a slave if SQL statement includes some special characters using Shift_JIS. The statement doesn't cause an error on the master, but it turns out to be an error on the slave.

How to repeat:
see the private note below.

Suggested fix:
[29 Sep 2009 8:04] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior with generic test and current development sources although problem is repeatable with version 5.0.79. Please upgrade, try with it and inform us if problem still exists.
[29 Sep 2009 8:14] Sveta Smirnova
Also is interesting why you say why this is Shift_JIS while real query in the relay log is in UTF8.
[29 Sep 2009 8:40] MySQL Verification Team
Please let me correct the summary. The character set in question is 'utf8' not Shift_JIS.
[30 Oct 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".