Re: setting utf8 in my.cnf..

[Dr Tebi]

Another year later... just in case someone is wondering.

When I installed mysql, I set the default charset to utf8:

make WITH_CHARSET="utf8"

When checking the variables, my output shows:

+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+

And, as a matter of fact, I have not specified any charset in the my.cnf file.

This is on MySQL 5.0.51a on a FreeBSD 7.0 system.

DrTebi