16 Mar
2007
16 Mar
'07
4 p.m.
Some ideas:
* Check that the tables are really using UTF-8: get a mysql shell, open the
xwiki database and type "select charset(xwd_content from xwikidoc;". If it
does not say UTF-8, then you need to change the encoding. I've attached a
script that tries to do that (and creates indexes, too)
* Check that the mysql connections are set to UTF-8. "show variables like
'character_set%';". If it says something else, you can either globally set
the mysql encoding to utf-8 (in the mysql configuration file, search the
mysql documentation), or configure hibernate to request this:
<xwiki-dir>/WEB-INF/hibernate.cfg.xml, add
<property name="connection.characterEncoding">utf8</property>
after:
<property name="connection.driver_class">com.mysql.jdbc.Driver
</property>
* Check that you set all the encoding parameters to UTF-8:
** in WEB-INF/xwiki.cfg: xwiki.encoding=UTF-8
** in WEB-INF/web.xml:
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
** in WEB-INF/velocity.properties:
input.encoding=UTF-8
output.encoding=UTF-8
After this, it should work just fine.
Sergiu
On 3/16/07, ning wang <daning106(a)gmail.com> wrote:
I write Chinese characters with Xwiki.
I have change the encoding to UTF-8. Futhermore, I set mysql default
encode to UTF-8.
The Wiki can work well to display Chinese in the edit situation and view
situation.
After I change the wiki by writing Chinese in it. And change it again. If
I roll back the version, the Chinese characters will become something like
"?????".
How to solve this problem?
Thanks,
Wang Ning
--
http://purl.org/net/sergiu