[Koha] MySQL and utf8
Beda Szukics
beda at muri-gries.ch
Wed Oct 3 07:29:02 NZST 2007
Hi all
I try to set up my server (debian 4.0) for koha and I follow the guidelines
in:
http://wiki.koha.org/doku.php?id=encodingscratchpad
to make shure the encondings are right.
Now I have a problem setting up MySQL:
I added the three lines suggested:
init-connect = 'SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
in my.cnf in the section [mysqld]
Some of the variables suggested remain still latin1
mysql> show variables like "char%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
mysql> show variables like "coll%";
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
Is that a problem? What do I have to change to make the system utf8-proof?
Thank you Beda
More information about the Koha
mailing list