How to enable UTF-8 to Unicode translation?

Question

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 "???????".

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

Answer 1

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

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