showing data in mysql with c# RRS feed

  • Question


    i have some question about c# and mysql.
    1.  i have a problems with inserting persian character in mysql with
    i use mysql connector net version for connect mysql to .net .
    if i use "SQL MANAGER FOR MYSQL "(a interface for manipulate of data in mysql) for insert data(persian character )  everythings is ok and i can insert , update persian character and it show this character correct but i have  problems in myproject that i writed it with c#. my project can show correct charcter that it insert via  "SQL MANAGER FOR MYSQL " but if i insert data with my project , it show ??? instead of persian character.
    i think this problem is for codepage of form of myproject and i tested unicode and arabic codepage but any codepage isn't useful. i don't know how can i solve this problem.
    is Thread.CurrentThread.CurrentUICulture =  new System.Globalization.CultureInfo("fa-IR"); about this problem and can it solve this problem?
    (i tested this code but my problem diden't change)
    2. the code  " myAdapter.Fill(myDataSet, "mytable");" has this error "unable to convert mysql date/time value to System,DateTime".
     what is problem?
    Could you help me,please?
    Best Regards;
    Sunday, July 6, 2008 12:06 PM