3
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?

Marcus Adams
  • 53,009
  • 9
  • 91
  • 143
Hidden
  • 3,598
  • 4
  • 34
  • 57

1 Answers1

6

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

Connection.SpecificOptions.Values['MySQL.UseUnicode'] := 'True';
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