List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:November 14 2004 2:59pm
Subject:RE: Illegal mix of collations
View as plain text  
See my responses to the other illegal mix of collation errors on this list.

-----Original Message-----
From: nil18@stripped [mailto:nil18@stripped] 
Sent: Thursday, October 28, 2004 4:49 PM
To: dotnet@stripped
Subject: Illegal mix of collations 

Hi!

I'm using the .NET Connector version 2, because i got a strange "read_only"
error in version 1. So i added the new dll to my directory and hoped that
the old code will work now.
But a new error occured.
I hope you can help me.
Here's the code:

private void Button1_Click(object sender, System.EventArgs e)
{	
   string x="'"+tb2.Text+"%'";
   string bla = "SELECT * from name where Name like "+x;
   string cs = "SERVER = localhost; DATABASE = gerrit; UID = root;
PASSWORD=vikings;";
    MySql.Data.MySqlClient.MySqlConnection con = new
MySql.Data.MySqlClient.MySqlConnection(cs);
    MySql.Data.MySqlClient.MySqlCommand test = new
MySql.Data.MySqlClient.MySqlCommand(bla,con);
    con.Open();
    MySql.Data.MySqlClient.MySqlDataReader read = test.ExecuteReader(); //
here is the error
    while(read.Read())
    {
         string Name = (string) read["Name"];
          tb.Text = tb.Text + " " +Name+ "\n";
    }
    read.Close();
    read=null;
    con.Dispose();
    con.Close();
    con=null;
}

The error is following:

#HY000Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation 'like' 

Zeile 60: MySql.Data.MySqlClient.MySqlCommand test = new
MySql.Data.MySqlClient.MySqlCommand(bla,con);
Zeile 61: con.Open();
Zeile 62: MySql.Data.MySqlClient.MySqlDataReader read =
test.ExecuteReader(); // here is the error
Zeile 63: while(read.Read())
Zeile 64: {

I really hope you can help me!

Thank you very much.
Greetings from Austria
Gerrit

-------------------------------------------
Versendet durch AonWebmail (webmail.aon.at)

-- 
MySQL on .NET Mailing List
For list archives: http://lists.mysql.com/dotnet
To unsubscribe:    http://lists.mysql.com/dotnet?unsub=1

Thread
Illegal mix of collationsnil1828 Oct
  • RE: Illegal mix of collationsReggie Burnett14 Nov