MySQL Forums
Forum List  »  Connector/NET and C#, Mono, .Net

Advanced Search
New Topic

Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Posted by: William Speirs
Date: November 10, 2004 11:26PM

Hey-

Well as I understand it, the newer version of MySQL lets you have different language support and therefore different ways to compare strings. So when I setup my database I chose latin1, but when I made a new column using the .NET connector it made it as utf8 by default. Then when I tried to do an update it was trying to compare latin1 & utf8 strings and couldn't.

However, I'm not sure why you would get the error you are getting with those lines.

Also Reggie Burnett appears to know a whole lot more about this then me. Apparently he is involved in writing the .NET connector, and as we all know; those who code it know it best...

BTW, thanks Reggie, or whom ever created the .NET connector. I'm really blown away at how simple these things are... once I got the whole latin1 thing worked out ;-)

Bill-

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
William Speirs
November 08, 2004 10:43PM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Reggie Burnett
November 09, 2004 03:59PM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
William Speirs
November 09, 2004 10:28PM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Reggie Burnett
November 10, 2004 08:28AM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Ken Allen
November 10, 2004 05:34PM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
William Speirs
November 10, 2004 11:26PM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Ken Allen
November 12, 2004 03:44PM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Reggie Burnett
November 16, 2004 11:46AM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Joshua Brickel
November 17, 2004 09:05AM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Joshua Brickel
November 17, 2004 05:24AM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Martin Sanneblad
November 18, 2004 08:17AM
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Joshua Brickel
November 18, 2004 11:37AM


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.