« Return to Thread: UTF Problems

Re: UTF Problems

by Jorge Bastos :: Rate this Message:

Reply to Author | View in Thread

Ah!

Tomas, you're not using the MySQL ADO.NET driver!
You're uding the MySQL ODBC Driver, diferent things.


DRIVER={MySQL ODBC 3.51
Driver};SERVER=MyServerHere;DATABASE=MyDatabaseHere;UID=MyUserHere;PASSWORD=MyPasswordHere;character
set=utf8;pooling=false"



----- Original Message -----
From: "tomasofen" <tomasofen@...>
To: <dotnet@...>
Sent: Thursday, May 10, 2007 2:02 PM
Subject: Re: UTF Problems



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@...>
> To: <dotnet@...>
> 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@...>:
>>>
>>>
>>> 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=ahmet34@...
>>>
>>>
>>
>>
>
> --
> 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=mysql.jorge@...
>
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:    http://lists.mysql.com/dotnet?unsub=lists@...
>
>
>

--
View this message in context:
http://www.nabble.com/UTF-Problems-tf1225.html#a10412855
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=mysql.jorge@...



--
MySQL on .NET Mailing List
For list archives: http://lists.mysql.com/dotnet
To unsubscribe:    http://lists.mysql.com/dotnet?unsub=lists@...

 « Return to Thread: UTF Problems