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
