Re: Replication Error Illegal Mix of Collations
Ok, trying again. Somehow my previous two Posts did not reach the forum...
In the meantime i convienced the Customer to plan a downtime and do an update to 5.1 (we did not dare to go up to 5.6, because there seem to be quite a lot incompatibilitys from 5.1 to 5.5).
When we tested manually the replication worked fine. Also with strings with "Umlauts" (äöü). But soon after going live again we have the same Problem as before. Replication stops with Errors like:
Last_Error: Error 'Duplicate entry 'Steiner K-F?rstaller 04.0
8.-0-EGW980ST228-0-1-1' for key 'PRIMARY'' on query. Default database: 'lager'.
Query: 'INSERT INTO `lager`.`materialpostings` (`strJOB`,`nPARTIALRESULT`,`strMA
T`,`fTYPE`,`nTYP`,`strNR`,`nLENGTH`,`nWIDTH`,`nCOUNT`,`strTYPENR`,`fSAVESTATUS`)
VALUES ('Steiner K-F³rstaller 04.08.','0','EGW980ST228','0','1','1','2.80000000
000000000e+003','2.07000000000000000e+003','2','454','0')'
If i stop replication, enter the command manually on the mysql prompt (which runs fine), set the skip-counter to one and restart the replication, a few hundret positions in the log later i run into a similar error like the one above (with a different data set of course). It seems that theres always a "Umlaut" in a string (the ? in K-F?rstaller above should be a K-Fürstaller).
I have Version 5.1.72-community on both sides on Win7
Any ideas?