[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