Devart Forums

Thank you for Help. The problem solved.

I think I know how to fix problem with second DB. It is my DB. And I will recreate it with default charset then I will copy from second DB to this one new.

At this moment I should say I have two DB on that server.
The first has Client CharacterSet = default.
The second Client CharacterSet = utf8;

I put Character Set = auto to each connection string.
Now I get valid data from first DB.

From second DB I still get trash.

Hello. I have DB with umlaut letters. Db is MySQL 3.23.45. Default charset is latin1. When I get data using Devart dotConnect. I get trash instead umlaut letter.

What I should change to get valid letters?

I was trying to change charset in connection string to latin1. It is not help, I get exception "Client character set 'utf8' is different from server character set 'latin1'.".

If change to utf8 It gets exception. I was trying set Unicode=true in connection string and in connection object in code. But I get exception like "Client character set 'utf8' is different from server character set 'latin1'."

How to read umlaut letter?

P.S. Server Explorer in VS2010 not read umlaut letters too when I use dotConnect.