Problem with UTF-8 in MySQL

[john j]

Greeting
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

[Ady]

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,

Ady

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.

[Qutfullo]

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!​

[Ady]

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.

Regards,
Ady
Telerik