Result data charset is mismatch

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
shaharw18
Posts: 43
Joined: Thu 20 Oct 2011 20:07

Result data charset is mismatch

Post by shaharw18 » Sat 07 Sep 2013 13:44

Hi,

I've created a linqConnect model using the developer.
and when displaying data on the website I'm getting giberish.
when issueing a SELECT query to retrieve data, I can see that the data is ok and in the right charset. the problem is only in the web application.
in the html head i'm using utf-8 charset.

what can be the problem?

Shahar Weinstein.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Result data charset is mismatch

Post by MariiaI » Tue 10 Sep 2013 13:37

We couldn't reproduce this issue on our environment. Please specify the following:
- the version of the MySQL server you are working with;
- your connection string; the Unicode connection string parameter value - True of False ( open Database Explorer, right- click on Database Connection->Edit Connection Properties->Advanced);

Also, if possible, please send us a small test project, with which this error could be reproduced.

shaharw18
Posts: 43
Joined: Thu 20 Oct 2011 20:07

Re: Result data charset is mismatch

Post by shaharw18 » Tue 10 Sep 2013 16:12

Thank you very much!

adding the unicode parameter to the connection string.
fixed the problem.


Shahar Weinstein.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Result data charset is mismatch

Post by MariiaI » Wed 11 Sep 2013 05:12

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.

Post Reply