hi, if you still did not managed to make it work with odbc driver, then
i'm afraid you wont :( i had been fighting the same issue for a very
long time without effect. it seems like the MySQL ODBC driver is not
capable of doing all the communication in utf-8. what's worse it almost
looks like this driver is frozen for years.
i suggest you switch to Connector/Net it's easier to use and it just
works. i had a luck of using my own DbWrapper class that was wrapping
the db communication so the only thing i had to do was to change the
wrapper without touching the application's code and all runs now just fine.
tomasofen wrote:
> I had in my connection string "charset=utf8". I changed it for this one you
> tell, "character set=utf8", but it doesn't work...
>
> This is at this moment my connection string:
>
> DRIVER={MySQL ODBC 3.51
>
> Driver};SERVER=MyServerHere;DATABASE=MyDatabaseHere;UID=MyUserHere;PASSWORD=MyPasswordHere;character
> set=utf8;pooling=false"
>
>
>
>
> Jorge Bastos wrote:
>> What about your connection string, do you have?
>> "character set=utf8"
>>
>>
>>
>>
>>
>> ----- Original Message -----
>> From: "tomasofen" <tomasofen@stripped>
>> To: <dotnet@stripped>
>> Sent: Thursday, May 10, 2007 1:39 PM
>> Subject: Re: UTF Problems
>>
>>
>>
>> Yes
>>
>> I have in the doccument the following meta:
>>
>> <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
>>
>> And when you write russian text in a textbox it looks ok. And also the
>> program works ok with a Microsoft Access Database, so i suppose it is
>> correctly encoded in UTF8...
>>
>>
>>
>> Ahmet ÜK wrote:
>>> is your website and document coding in UTF-8?
>>>
>>>
>>> 2007/5/10, tomasofen <tomasofen@stripped>:
>>>>
>>>> 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.
>>>>
>>>>
>>>> --
>>>> MySQL on .NET Mailing List
>>>> For list archives: http://lists.mysql.com/dotnet
>>>> To unsubscribe: http://lists.mysql.com/dotnet?unsub=1
>>>>
>>>>
>>>
>> --
>> View this message in context:
>> http://www.nabble.com/UTF-Problems-tf1225.html#a10412558
>> Sent from the MySQL - .NET mailing list archive at Nabble.com.
>>
>>
>> --
>> MySQL on .NET Mailing List
>> For list archives: http://lists.mysql.com/dotnet
>> To unsubscribe:
>> http://lists.mysql.com/dotnet?unsub=1
>>
>>
>>
>> --
>> MySQL on .NET Mailing List
>> For list archives: http://lists.mysql.com/dotnet
>> To unsubscribe: http://lists.mysql.com/dotnet?unsub=1
>>
>>
>>
>
----------------------------------------------------------------------
Ile masz w domu niepotrzebnych rzeczy?
Wymien sie z sasiadami >> http://link.interia.pl/f1a93
