[Koha-bugs] [Bug 11906] Bad display of utf-8 chars in Patron lists (Datatable)
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Mar 20 15:45:13 CET 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11906
--- Comment #7 from Marc Véron <veron at veron.ch> ---
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.
More information about the Koha-bugs
mailing list