Illegal mix of collations?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Guest

Illegal mix of collations?

Post by Guest » Thu 13 Jan 2005 04:02

Getting the following error:
Error occurred. SQL Error has occurred. Please check your ConnectionString/Table/Field settings. Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='\n

The connection string I am using is as follows:
Data Source=Inspiron;Database=globecast;User ID=globecast;Password=xxxx;Unicode=false;Pooling=true;Min Pool Size=0;Max Pool Size=20"

The following results were pulled when I run "show variables like 'colla%'
collation_connection = latin1_swedish_ci
collation_database = latin1_swedish_ci
collation_server = latin1_swedish_ci

I read on mysql.com that I could set the charset in the connection string... however MySQLDirect.NET does not offer this property. Any suggestions as to how I fix this?

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: Illegal mix of collations?

Post by Oleg » Thu 13 Jan 2005 15:39

Try to execute command:

Code: Select all

SET NAMES 'charset_name'

Post Reply