Problem with UTF-8 in MySQL

4 posts, 0 answers
  1. john j
    john j avatar
    1 posts
    Member since:
    Oct 2009

    Posted 05 Dec 2009 Link to this post

    I am using ORM to connect MySQL to ASP.Net and When I try to save UTF-8 (Arabic text )  to the database it saved  as (?????)
    but when I save tis text directly to the database it work , so how can I make the ORM pass UTF-8 or Unicode Data Correctly to the database

    Best Wished
  2. Ady
    Ady avatar
    588 posts

    Posted 10 Dec 2009 Link to this post

    Hello john j,

     You can use the 'Connection Settings' dialog (OpenAccess->Configuration->Connection Settings) and specify the 'connectionParams' value to 'charset=utf8'. This will ensure that the values get written properly.

     Hope this helps.

    Best wishes,
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. DevCraft banner
  4. Qutfullo
    Qutfullo avatar
    3 posts
    Member since:
    Sep 2015

    Posted 21 Oct 2015 Link to this post

    Hello Ady I used this connection: user id=root;host=localhost;database=xxx;persist security info=True; charset=utf8. This connection right or no. If add to table every data is ????????

    Best Wished!​

  5. Ady
    Ady avatar
    588 posts

    Posted 26 Oct 2015 Link to this post

    Hello Qutfullo ,

     What is the data type of the column in the database and the character set for the table? You should set the 'utf8' character set at the server,database or table level.

    Looking forward to your reply.

    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
Back to Top