Re: UTF Problems

Hi

I have the same problem...

I have a MySQL database where i can save Rusian characters using PHPMyAdmin or "MySQL Query Browser", and i can see the characters all right.

When i try to save or read russian characters in the MySQL database using my ASP .NET web application, the process fails. The data saved in MySQL results in characters like this "? ? ? ? ?".

The fact is that i test my ASP .NET application with a microssoft access database, and it works ok, saving and reading the russian characters ok.

I install MySQL allowing multilanguage, so it is supposed to use utf8. I check the table deffinition where i want to save the data, and it is of course as utf8.

I supposed it could be sommething in the connection string like that you explain in here, but i try to insert the "charset=utf8" in the connection string and it doesn't work neither. The current connection string i'm using is this:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=MyServerHere;DATABASE=MyDatabaseHere;UID=MyUserHere;PASSWORD=MyPasswordHere;OPTION=3;charset=utf8"

I tried some changes to this string, like adding "pooling", or delete "option", but nothing works...

I'm near to desesperation, becouse i don't know what else can i try :(

Please, any idea there??

Thanks in advance,

Tomas