Illegal mix of collations?

Illegal mix of collations?

Postby 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 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?

Re: Illegal mix of collations?

Postby Oleg » Thu 13 Jan 2005 15:39

Try to execute command:
Code: Select all
SET NAMES 'charset_name'
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Return to dotConnect for MySQL