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@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

<updatedb.sql>

--

You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list.

To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org

For general help: mailto:sympa@objectweb.org?subject=help

ObjectWeb mailing lists service home page: http://www.objectweb.org/wws