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

enter image description here

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

Have you tried `Connection.SpecificOptions.Values['MySQL.UseUnicode'] := 'True';`? — Jens Mühlenhoff, Oct 09 '13 at 12:01
Thanks, that worked for me. Post it as answer i will accept it. — Hidden, Oct 09 '13 at 12:07
@The downvoter: Please write down as comment why you voted down .... — Hidden, Oct 09 '13 at 12:07

score 6 · Accepted Answer · answered Oct 09 '13 at 12:43

6

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

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

answered Oct 09 '13 at 12:43

Jens Mühlenhoff

14,565
6
56
113

Alternatively, you could use the [set names](http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html) SQL command after you establish the connection like `SET NAMES utf8`, but you would be responsible for using the proper field types. – Marcus Adams Oct 09 '13 at 12:59

How to enable UTF-8 to Unicode translation?

1 Answers1