Last post Jan 07, 2014 08:25 AM by souhail
Jan 06, 2014 11:32 AM|souhail|LINK
I Buil New Asp.net Project ..
and I Connect to mysql DB with MySqlConnctor ,The Charset of the date :
utf8_unicode_ci and contains arabic strings .
The Data Appeare as Correpterd "
ÙŠØ¹Ù…Ø± Ø¯Ø±ÙˆÙŠØ´ Ø§Ù„Ø²ÙˆÙ†ÙŠ"
But when it's appear in php .. every thing looks fine ..
I try to ser the pages to utf8 , it's not worked ..
and tried to set from connection string as "Server=Myserver;Port=3306;Database=DB;Uid=root;Pwd=password;pooling=false;charset=utf8".. also didn't work ..
any Soulutions or ideas for that ?? !
Jan 06, 2014 11:55 AM|smirnov|LINK
What is the encoding of the asp.net page or entire application? It might be that the string is coming correct as UTF-8 from the database but you show it using different encoding - for example CP1252.
Try to set <meta
http-equiv="Content-Type" /> in the page
Jan 07, 2014 04:15 AM|souhail|LINK
I set It .. It's Not worked ..
Plz Note that the mysql workbensh also show the data as correpted ..
Jan 07, 2014 04:52 AM|smirnov|LINK
Jan 07, 2014 05:11 AM|souhail|LINK
Both are UTF8
Jan 07, 2014 05:30 AM|smirnov|LINK
According to following links parameter name may be case sensitive with upper case C
try to use "Charset=utf8" (instead of "charset=utf8")
or "UTF8" http://www.connectionstrings.com/mysql-connector-odbc-3-51/
Jan 07, 2014 08:25 AM|souhail|LINK
utf8 and utf-8 is same Data , Nothing Chanded ..
UTF8 Is Wrong Conncetion String ..