List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:December 10 2004 3:26pm
Subject:RE: Set names
View as plain text  
Nicholas

What version of the connector are you using?  Version 1.0.2 added support
for the charset option on the connection string.

-reggie

> -----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 &
> ";pooling=false;setnames=utf8;"
> 
> Would this be feasible?  I tried CHARSET=utf8; but that didn't work as
> CHARSET is an unknown parameter.
> 
> Regards,
> Nick.


Thread
Set namesNicholas Large10 Dec
  • RE: Set namesReggie Burnett10 Dec