15 messages in com.mysql.lists.dotnetRe: UTF Problems
FromSent OnAttachments
Andrés Villanueva28 Apr 2005 06:00 
Reggie Burnett28 Apr 2005 06:39 
Andrés Villanueva28 Apr 2005 07:38 
Reggie Burnett28 Apr 2005 07:59 
tomasofen10 May 2007 05:28 
Ahmet ÜK10 May 2007 05:33 
tomasofen10 May 2007 05:39 
Jorge Bastos10 May 2007 05:49 
tomasofen10 May 2007 06:02 
tomasofen10 May 2007 06:10 
Jorge Bastos10 May 2007 07:44 
tomasofen10 May 2007 08:00 
Jorge Bastos10 May 2007 08:16 
DG...@ NEFACOMP10 May 2007 09:57 
SharpCoderMP28 May 2007 01:41 
Subject:Re: UTF Problems
From:Ahmet ÜK (ahme@gmail.com)
Date:05/10/2007 05:33:01 AM
List:com.mysql.lists.dotnet

is your website and document coding in UTF-8?

2007/5/10, tomasofen <toma@yahoo.es>:

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,