Click here to Skip to main content
15,897,891 members

MySql & C# & the arabic !!!

Revision 1
Dear all
now i have a table contain a column which holds arabic text , now i am sure that the col. char set is utf8 and collection is utf8_unicode_ci and here is the conn. string

Driver={MySQL ODBC 3.51 Driver};Server=XXX ;Port=3306;Database=XXX;User=root;password=XXX;Option=3;CharSet=UTF8;

when i read the table using MySql Workbench it display the arabic text very well
when i read it using Navicate Lite also display it fine
when i read it using my software C# + Vs2005 , it display strange letters (i tried textbox & a datagridview)

so what should i do ?? i checked alot of google results and no way
some sites said u must query " set names = utf8 " before every query but i don't know how to insert it in the code since i am using tableadaptor & bindingsource so i don't write sql command direct in the code ??

thanks all
bye
Posted 9-May-11 2:25am by AhmedOsamaMoh.
Tags: ,