What version of the connector are you using? Version 1.0.2 added support
for the charset option on the connection string.
> -----Original Message-----
> From: Nicholas Large [mailto:nlarge@stripped]
> Sent: Friday, December 10, 2004 9:22 AM
> To: dotnet@stripped
> Subject: Set names
> Hello all.
> I have recently managed to store unicode characters in a mysql database
> using VB.NET with Mysql 4.1.7.
> It really is christmas!!!
> I recently got the error : "Invalid Character Set Index: 192" when
> trying to update the adapter from a dataset object. The issue was
> resolved by issueing the command "Set names utf8;" on every select
> statement to ensure that the connection was reading and writing in the
> same character set. It seems like a pain in the neck to have to do so
> every time, and I would prefer to not have to write a separate function
> which returns a connection in utf8, then call it every time I want to
> communicate with the database, and also it will make the "adapter.Fill"
> command quite messy so I am requesting that it be made possible that an
> additional parameter be added to the connection string for setnames.
> This would automatically update the connection to a particular character
> set (in this case utf8), every time the connection is opened.
> So, the connection string would look something like:
> MyODBC_ConString = "Persist Security Info=False;" & _
> "server=" & server & ";" & _
> "database=" & database & ";" & _
> "user id=" & user & ";" & _
> "pwd=" & password &
> Would this be feasible? I tried CHARSET=utf8; but that didn't work as
> CHARSET is an unknown parameter.
|• Set names||Nicholas Large||10 Dec|
| • RE: Set names||Reggie Burnett||10 Dec|