[mysqld] default-character-set=utf8 character-set-server=utf8 [mysql] default-character-set=utf8 [client] default-character-set=utf8 If you change conf file, please restart service (of course..)
-----Oorspronkelijk bericht----- Van: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] Namens Zeno Tajoli Verzonden: donderdag 22 december 2011 12:48 Aan: koha@lists.katipo.co.nz Onderwerp: [Koha] Experience with msyql setup for utf-8
Hi to all,
I'm checking the setup of a new Koha site, and I'm sure that we will deeply use UTF-8.
In /etc/mysql/my.conf, section [mysqld] I have insert: init-connect = 'SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci character_set_client=utf8
In fact is what is written here: http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha
Well, if I do a check on mysql with root user I see: mysql> show variables where variable_name LIKE "character_set%" OR variable_name LIKE "collation%"; +--------------------------+----------------------------+ | 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/ | | collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +--------------------------+----------------------------+
I use msyql 5.1 on Debian
Do you think is a coerent situation ?
Which experience do you have with mysql utf-8 setup ?
Bye Zeno Tajoli
-- Dott. Zeno Tajoli tajoliAT_SPAM_no_prendiATcilea.it fax +39 02 2135520 CILEA - Consorzio Interuniversitario http://www.cilea.it/disclaimer _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha