[Koha] Koha and UTF-8 (again)

"Thommy M. Malmström" thommy.m.malmstrom at gmail.com
Tue Jan 6 22:47:07 NZDT 2009


Once again I took the fight with Koha to try to make it work with non 
ASCII characters. I've set the the following variables for MySQL, Apache 
and PHP:


     vim /etc/apache2/apache2.conf
     AddCharset UTF-8 .utf8
     AddDefaultCharset UTF-8

     vim/etc/php5/apache2/php.ini
     default_charset = "utf-8"



     vim /etc/mysql/my.cnf
     [client]
     character_set_client=utf8
     [mysql]
     default-character-set=utf8
     [mysqld]
     init-connect = 'SET NAMES utf8'
     character-set-server=utf8
     collation-server=utf8_swedish_ci

     /etc/rc3.d/S19mysql restart

     mysql> SHOW VARIABLES LIKE 'character_set%';
     +--------------------------+----------------------------+
     | 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/ |
     +--------------------------+----------------------------+
     8 rows in set (0.01 sec)

     mysql> SHOW VARIABLES LIKE 'collation%';
     +----------------------+-----------------+
     | Variable_name | Value |
     +----------------------+-----------------+
     | collation_connection | utf8_general_ci |
     | collation_database | utf8_swedish_ci |
     | collation_server | utf8_swedish_ci |
     +----------------------+-----------------+
     3 rows in set (0.00 sec)





However when I try to add an item it cuts of the text at the non ASCII 
char. Please look at the pictures here to see what I mean:

http://thommym.blogspot.com/2009/01/koha-and-utf-8.html

Also in I add text for members etc. with non ASCII chars in it it is cut 
at the non ASCII position.

So, anyone to my rescue???



More information about the Koha mailing list