Groups > Databases > MySQL for ASP.NET > Re: MySQL & ASP.NET Encoding Problem!!!!




MySQL & ASP.NET Encoding Problem!!!!

MySQL & ASP.NET Encoding Problem!!!!
Sun, 24 Feb 2008 21:03:01 +000
Hi,

I'm tring to retrieve data from a MySQL table and show them in a ViewGrid on my
ASP.NET page but I'm getting '??????????' instaed of the real data.

I even tried to view it as a plain text on my page with no luck!!!

My ASP.NET page encoded and saved as UTF-8. 

MYSQL Fields:

title : varchar(120) : latin1_swedish_ci

Body : varchar(20) : utf8_general_ci

I tried to set the Charset=UTF-8 in the connection string but it's the same.

I'm also facing the same problem when trying to move data from MySQL to MSSQL
2005! 

Any Ideas about encoding? 

Note: when I use MySQl Managment program I see (Set names 'utf8') in its
history, how can apply this using ASP.NET?

Thanks
Post Reply
Re: MySQL & ASP.NET Encoding Problem!!!!
Sun, 24 Feb 2008 22:30:08 +000
see this url for details http handler 

http://www.w3.org/International/O-HTTP-charset
Post Reply
about | contact