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.