List:MySQL and .NET« Previous MessageNext Message »
From:Jordan Sparks Date:November 14 2004 6:09pm
Subject:RE: New error with Beta 2
View as plain text  
That is correct.

Jordan Sparks
 

-----Original Message-----
From: Jorge Bastos [mailto:mysql.jorge@stripped] 
Sent: Sunday, November 14, 2004 9:45 AM
To: dotnet@stripped
Subject: Re: New error with Beta 2


mysql 4.0.x doesn't support utf8 right?
only from >= 4.1.x right?

Jorge

----- Original Message ----- 
From: "Reggie Burnett" <reggie@stripped>
To: "'Scott Underwood'" <scott@stripped>; <dotnet@stripped>
Sent: Sunday, November 14, 2004 2:59 PM
Subject: RE: New error with Beta 2


> 1.0.2 will help with this since you can specify the proper charset on 
> the connection string.
>
> -----Original Message-----
> From: Scott Underwood [mailto:scott@stripped]
> Sent: Friday, October 29, 2004 8:09 AM
> To: dotnet@stripped
> Subject: New error with Beta 2
>
> I haven't seen this error before, at least not with the .76 version of

> ByteFx or Beta 1.0 of the connector.  When I fill a dataset using 
> interfaces I get the following:
>
> #HY000Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
> (utf8_general_ci,COERCIBLE) for operation '='
>
> The code that I'm using to fill the adapter is:
>
> Dim cmd As IDbCommand = lDbC.CreateCommand 'lDbC is an IDbConnection 
> object
>       cmd.CommandText = SQL
>       lDbA = lDf.GetDataAdapter 'lDbA is an IDbDataAdapter object
>       lDbA.SelectCommand = cmd
>       Dim ds As New DataSet
>       If lDbC.State <> ConnectionState.Open Then lDbC.Open()
>       lDbA.Fill(ds)
>       If lDbC.State = ConnectionState.Open Then lDbC.Close()
>       If ds.Tables(0) Is Nothing Then
>       Throw New DatabaseException("Failed to retrieve data table.",
> "1x007")
>       Else
>       Return ds.Tables(0)
> End If
>
> The query that I'm running is "SELECT UserName,
> AES_DECRYPT(Password,'test') FROM sec_users WHERE UserName='" & User &

> "'"
>
> All of the tables in the database use the Latin1 character set so I'm 
> not sure where the UTF8 is coming from or if there is a connection 
> string option that I can use to ignore the colation settings.  Any 
> help is much appreciated.
>
> Thanks
> Scott
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1
>
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1
>
>


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


Thread
New error with Beta 2Scott Underwood29 Oct
  • RE: New error with Beta 2Reggie Burnett14 Nov
    • Re: New error with Beta 2Jorge Bastos14 Nov
      • RE: New error with Beta 2Jordan Sparks14 Nov