Since v2.6.1
Sets connection collation.
Syntax:
property ConnectionCollation: String;
Description:
DAC for MySQL executes 'SET NAMES <character set name> COLLATE <collation name>' query immediately after connection to database is established, if at least one of ConnectionCharacterSet or ConnectionCollation properties values is not set in empty string.
For details about character sets and collations in MySQL please refer to http://dev.mysql.com/doc/refman/5.0/en/charset.html
Every character set has its own set of collations.
You can get supported collations list by executing SHOW COLLATION LIKE 'utf8%' query replacing utf8 with desired character set.
See also: ConnectionCharacterSet property