Re: UTF Problems - Jorge Bastos - com.mysql.lists.dotnet

15 messages in com.mysql.lists.dotnetRe: UTF Problems

From	Sent On	Attachments
Andrés Villanueva	28 Apr 2005 06:00
Reggie Burnett	28 Apr 2005 06:39
Andrés Villanueva	28 Apr 2005 07:38
Reggie Burnett	28 Apr 2005 07:59
tomasofen	10 May 2007 05:28
Ahmet ÜK	10 May 2007 05:33
tomasofen	10 May 2007 05:39
Jorge Bastos	10 May 2007 05:49
tomasofen	10 May 2007 06:02
tomasofen	10 May 2007 06:10
Jorge Bastos	10 May 2007 07:44
tomasofen	10 May 2007 08:00
Jorge Bastos	10 May 2007 08:16
DG...@ NEFACOMP	10 May 2007 09:57
SharpCoderMP	28 May 2007 01:41

Subject:	Re: UTF Problems
From:	Jorge Bastos (mysq...@decimal.pt)
Date:	05/10/2007 08:16:12 AM
List:	com.mysql.lists.dotnet

Well... no idea, i never used ODBC, only tryed to connect etc etc. There another version of the ODBC driver: http://dev.mysql.com/downloads/connector/odbc/5.0.html

try in a test application if it works ok with it, if not... don't know :)

Jorge

----- Original Message ----- From: "tomasofen" <toma...@yahoo.es> To: <dot...@lists.mysql.com> Sent: Thursday, May 10, 2007 4:01 PM Subject: Re: UTF Problems

Ah, ok

The application is very big, and it's right it uses connections with odbc. Dued to it's size i can't think in chage it to ADO .NET at this moment...

Is there any problem with this using ODBC? Or perhaps this is not the right thread to ask about it?

Tomás

Jorge Bastos wrote:

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" <toma...@yahoo.es> To: <dot...@lists.mysql.com> 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" <toma...@yahoo.es> To: <dot...@lists.mysql.com> Sent: Thursday, May 10, 2007 1:39 PM Subject: Re: UTF Problems

Yes

I have in the doccument the following meta:

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 <toma...@yahoo.es>:

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,