From: Scott Underwood
Date: October 29 2004 1:09pm
Subject: New error with Beta 2
List-Archive: http://lists.mysql.com/dotnet/109
Message-Id: <36E4523EB955E04CA78BA2BF0367D62A0552E5@morph.secdes.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

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 '=3D'

The code that I'm using to fill the adapter is:

	Dim cmd As IDbCommand =3D lDbC.CreateCommand 'lDbC is an
IDbConnection object
      cmd.CommandText =3D SQL
      lDbA =3D lDf.GetDataAdapter 'lDbA is an IDbDataAdapter object
      lDbA.SelectCommand =3D cmd
      Dim ds As New DataSet
      If lDbC.State <> ConnectionState.Open Then lDbC.Open()
      lDbA.Fill(ds)
      If lDbC.State =3D 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=3D'" & 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