Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
Posted by: Joshua Brickel
Date: November 17, 2004 05:24AM

Hi,

I just tried 1.0.2 off the mysql website. However when I tried to add the charset option to the connectionstring by the following....

_________ code snipet bgins ______________--

MySql.Data.MySqlClient.MySqlConnection myconnection;

string connectionString =
"Server=localhost;" +
"Database=test;" +
"User ID=mytest;" +
"Password=mytest;" +
"Charset=latin1;";

myconnection = new MySql.Data.MySqlClient.MySqlConnection(connectionString);

and then tried to

myconnection.open();

_______code snipet end ________________

I got an error message in the console window that said...

Unhandled Exception: System.ArgumentException: Keyword not supported: 'charset'
in <0x005c5> MySql.Data.MySqlClient.MySqlConnectionString:ConnectionParameterParsed (System.Collections.Hashtable,string,string)
in <0x00100> MySql.Data.Common.DBConnectionString:Parse (string)
in <0x00017> MySql.Data.Common.DBConnectionString:SetConnectionString (string)
in <0x00018> MySql.Data.MySqlClient.MySqlConnectionString:.ctor (string)
in <0x00034> MySql.Data.MySqlClient.MySqlConnection:.ctor (string)
in <0x00056> (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlConnection:.ctor (string)

Did I do something wrong? I should probably point out that I am trying to run this under Mono on a Debian Linux system.

Regards,

Joshua

Options: ReplyQuote


Subject
Written By
Posted
Re: Adapter Update Fails, Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '<=>'
November 17, 2004 05:24AM


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.