Illegal mix of collations?
Posted: 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?
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?