FreeBSD Port: mysql-server-5.5.15
Miroslav Lachman
000.fbsd at quip.cz
Tue Aug 16 11:27:14 UTC 2011
Hi,
I am trying MySQL 5.5.15 as it is the default version now, but I have a
problem with default charset.
I used WITH_CHARSET=utf8 WITH_XCHARSET=all WITH_COLLATION=utf8_czech_ci
on all our older MySQL servers (5.0 and 5.1). These knobs are no longer
available, so how can I set default charset and collation?
I tried following in my.cnf
[client]
default-character-set = utf8
[mysqld]
character-set-server = utf8
collation-server = utf8_czech_ci
But it gives me
mysql> SHOW VARIABLES LIKE '%collation%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_czech_ci |
| collation_server | utf8_czech_ci |
+----------------------+-----------------+
mysql> SHOW VARIABLES LIKE '%character%';
+--------------------------+----------------------------------+
| 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/ |
+--------------------------+----------------------------------+
On an older versions (compiled with WITH_ knobs) I have:
mysql> SHOW VARIABLES LIKE '%collation%';
+----------------------+---------------+
| Variable_name | Value |
+----------------------+---------------+
| collation_connection | utf8_czech_ci |
| collation_database | utf8_czech_ci |
| collation_server | utf8_czech_ci |
+----------------------+---------------+
mysql> SHOW VARIABLES LIKE '%character%';
+--------------------------+----------------------------------+
| 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/ |
+--------------------------+----------------------------------+
Note the difference in collation_connection!
Is there any official way to restore the old behavior, or should I
locally modify the port to support WITH_ knobs?
It seems related to this bug: http://bugs.mysql.com/bug.php?id=34980
Thanks in advance
Miroslav Lachman
More information about the freebsd-ports
mailing list