Re: How to set the default connection collation in config file?

[damjan]

I've read about this possibility, but it seems a bit hackish...

Unfortunatelly id doesn't even work, this is my /etc/my.cnf file now:
[client]
default-character-set = utf8

[mysqld]
character-set-server=utf8
collation-server=utf8_unicode_ci
init_connect='set collation_connection = utf8_unicode_ci;'

And I've restarted the server, but still when I connect with the 'mysql' command line utility the connection_collation is still utf8_general_ci. This is mysql-4.1.11.

mysql> show session variables like 'collation_connection';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
+----------------------+-----------------+
1 row in set (0.00 sec)