http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11906
--- Comment #7 from Marc Véron <[email protected]> --- I followed the advice on http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_tarball#Tweaking_my.cnf and http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha and added the following to: /etc/mysql/my.cnf ---------- [mysqld] init-connect = 'SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci character_set_client=utf8 ---------- Then I restarted mysql with: /etc/init.d/mysql restart As a result, I get the following in mysql: mysql> show variables like '%colla%'; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-----------------+ mysql> show variables like '%char%'; +--------------------------+----------------------------+ | 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/share/mysql/charsets/ | +--------------------------+----------------------------+ ...and the charecters now display fine. @ Tomás Cohen Arazi Having a MySQL configuration sanity check in about > system check would be great! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
