Arabic/International Characters retrieve as ???

Arabic/International Characters retrieve as ???

Postby emp51302 » Fri 14 Dec 2012 18:49

Hi - Is there any settings in dotConnect for Mysql so that international characters don't appear as question mark ???

for example شكرا
displays as ???? when saved or retrieved from database.

Please advise.

Thank you.
emp51302
 
Posts: 46
Joined: Fri 19 Aug 2011 20:57

Re: Arabic/International Characters retrieve as ???

Postby Pinturiccio » Tue 18 Dec 2012 08:56

Try using 'Unicode=true' parameter for your connection string or setting the Unicode property of your MySqlConnection object to 'true'. For more information, please refer to
http://www.devart.com/dotconnect/mysql/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlConnection~Unicode.html

You can also try using the Character Set parameter for your connection string or the Charset property of your MySqlConnection object. For more information, please refer to
http://www.devart.com/dotconnect/mysql/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlConnection~Charset.html
Pinturiccio
Devart Team
 
Posts: 1893
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL