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