Skip navigation links

MySQL Forums :: Replication :: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)


Advanced Search

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
Posted by: Michael Grubb ()
Date: November 22, 2004 08:31AM

Hello All,
I've asked this question on the main mysql mailing list but to no avail.
I've almost pulled what hair I have left out on this one =].

I keep getting the 'Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)' error on my slave.
(Actually I get this error a lot in other scenarios too but I've managed to find a work around for those)

This data was converted from a 3.x database (don't ask me what specific version b/c I don't remember but I think it was 3.23). Any help would be greatly appreciated.

Thanks again,

Michael Grubb

Options: ReplyQuote


Subject Views Written By Posted
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 68309 Michael Grubb 11/22/2004 08:31AM
Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 39393 Guilhem Bichot 12/14/2004 03:08PM
Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 27853 peter d 02/14/2005 04:12PM
Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 52233 Chuck Johnson 02/16/2005 02:56PM
Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 27019 09/03/2008 04:33AM
Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 17955 mcdonal boomblast 05/29/2009 05:26AM


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.