[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: [email protected] [mailto:[email protected]] > Namens Zeno Tajoli > Verzonden: donderdag 22 december 2011 12:48 > Aan: [email protected] > 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 > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
