mysqldelphicharacter-encodingdelphi-xe3unidac

How to enable UTF-8 to Unicode translation?

Database: utf8 
Collation: utf8_general_ci

I have the following problem:

When I execute my query everything is written correctly to the table except the Chinese characters and Cyrillic characters shows me only in the table field "???????".

enter image description here

Is there an option to change the charset in the unidac componenet or at the mysql server?

Solution

  • You have to set a driver specific option to enable Unicode translation:

    Connection.SpecificOptions.Values['MySQL.UseUnicode'] := 'True';