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
--
View this message in context: http://www.nabble.com/UTF-Problems-tf1225.html#a10412379
Sent from the MySQL - .NET mailing list archive at Nabble.com.