Xavier MOGHRABI wrote:
Le Jeudi 26 Mai 2005 20:29, Udo Bussmann a écrit :
Hello Xavier, have you applied UTF-8 to xwiki as it is explained here ? http://www.xwiki.org/xwiki/bin/view/Dev/CharactersSets
Yes, I've changed encoding in web.xml, xwiki.cfg, LANG variable and java option. For the database I try 2 ways, : 1. to set database encoding to UTF-8 by creating my database like this : create database xwiki character set utf8; It doesnt work : I have no error, it seems to work until I restart the server and my chinese characters disappear for "?" instead.
2. to change the server encoding by startiing it with this option --default-character-set=utf8 I get the last error message I posted.
It's really strange.
Hi Xavier, It might be worth checking whether all character-set-* variables are correctly set to "utf8" in the MySQL variables tables. I copy below what I get when running a "SHOW VARIABLES" against a MySQL 4.1 server that I use successfully with an XWiki containing Chinese documents: | character_set_client | utf8 | character_set_connection | utf8 | character_set_database | utf8 | character_set_results | utf8 | character_set_server | utf8 | character_set_system | utf8 | character_sets_dir | /usr/share/mysql/charsets/ | collation_connection | utf8_general_ci | collation_database | utf8_general_ci | collation_server | utf8_general_ci Here is also the part of my "/etc/my.cnf" file related to charset: [client] default-character-set=utf8 [mysqld] default_character_set=utf8 Hepe this holps, Stéphane
Xavier