26 May
2005
26 May
'05
10:50 p.m.
Xavier MOGHRABI wrote:
Le Jeudi 26 Mai 2005 20:29, Udo Bussmann a écrit :
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
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.
Xavier