Good morning,
Sorry the english, but I am Brazilian and I am using an online translator.
I'm having a problem in sync version of SQLyog Enterprise 6.13. When the sync, the system is returning me the following error:
`Invoice` Error 3426 3424 No. 1267
Illegal mix of collations (latin1_swedish_ci, IMPLICIT) and (utf8_general_ci, coercible) for operation '='
Error No. 1267
Illegal mix of collations (latin1_swedish_ci, IMPLICIT) and (utf8_general_ci, coercible) for operation '='
1st Phase: 0 0
Already changed the collation of the table of the source and target, but the problem still persists.
The my.ini is configured as follows:
Mysql and variables like this:
character_set_client utf8
character_set_connection utf8
character_set_database latin1
CHARACTER_SET_RESULTS utf8
character_set_server latin1
character_set_system utf8
In total I have 100 tables and only one is in the problem.
The other is to sync with no problem.
I do not know what else to try to resolve the problem.
I hope someone can pass me a solution.
