MySQL Forums
Forum List  »  Other Migration

Illegal mix of collations after migrating
Posted by: Cain Nuke
Date: May 19, 2012 12:16AM


im migrating from a windows server to a linux server. On the windows server i have no problem but on linux im getting this error:

Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

i really dont know why it happens because the same database works just fine on Windows so i wonder whether its an import error or a problem in the linux server configuration. Could you please help me?

Thank you.

Options: ReplyQuote

Written By
Illegal mix of collations after migrating
May 19, 2012 12:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.