illegal mix of collations
Posted by: Andy Solomon
Date: November 04, 2004 01:59PM

I get the following error when I try to update a table using the .NET connector:

Illegal mix of collations (latin1_swedish_ci, IMPLICIT) and (utf8_general_ci, COERCIBLE) for operation '=' error

I do not get errors on insert, delete or select statements. I don't get the error when using an ODBC driver. I've run the statement through the MySQL Query Browser and it returns no error either. Is there a simple solution to this error? I've tried changing the Column Charset through MySQL Administrator, but it doesn't appear to help. I'm currently running everything on my local machine.

Options: ReplyQuote

Written By
illegal mix of collations
November 04, 2004 01:59PM
November 05, 2004 10:53AM
November 09, 2004 03:57PM

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.