Re: How to set the default connection collation in config file?
Posted by: damjan
Date: August 26, 2005 11:57AM

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)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to set the default connection collation in config file?
13494
August 26, 2005 11:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.