Re: [xwiki-users] problem with Chinese

2007/3/20, Youcef BEY < youcef.bey(a)imag.fr&gt;gt;: Hi Wang, This problem have also took for longtime to solve it (in fact, I faced it before and hope that it correspond to yours). So I am using multilingual data in my XWiki (Arabic, Chinese, English, French and Japanese) and everything is working well with the UTF-8 encoding (MySQL, Tomcat, XWiki). I read all your emails and responses. It seems that someone adviced you to check again the database encoding. Yes, the problem is related to the encoding of char in the database and it is simple to solve. In fact, it seems that MySql display that it's char encoding is in UTF-8 but you need also to add the following lines to my.cnf : In my system, there is only my.ini. So I edit my.ini following your advise below. [client] default-character-set=utf8 [mysqld] default-character-set=utf8 character-set-server = utf8 collation-server = utf8_general_ci Also check the following parameters for your Tomcat UTF-8 encoding (for linux, check catalina.sh): I use Tomcat 5.5. I can't find something like start.bat. So I don't know how to set Tomcat to UTF-8 encoding. May you tell me the detail? --------------------------------------------------------------------- -------------------------------- echo off rem set LANG=fr_FR.ISO8859-1 set LANG=en_US.UTF-8 set JETTY_PORT=8080 set JETTY_HOME=. java %JAVA_OPTS% -Djetty.port=%JETTY_PORT% -Djetty.home=%JETTY_HOME % -Dfile.encoding=UTF-8 -jar %JETTY_HOME%/start.jar Add the following variables to your system ----------------------------------------------------------- LANG = en-US_UTF8 Change the XWiki encoding : ----------------------------------------- (i) XWiki.xml encoding = UTF-8 (ii) XWiki.cfg CharSet = UTF-8 I do what I can, But there still do not work. "???" still exist. If this configuration work well, so we need after that to write (as suggested) a document for helping new users. Please let us know whether it work? Cheers ---------------------------------- Youcef Bey Graduate School of Education, The University of Tokyo, ----- Original Message ----- From: ning wang To: xwiki-users(a)objectweb.org Sent: Friday, March 16, 2007 11:27 AM Subject: Re: [xwiki-users] problem with Chinese Hi Jimmy, I tried again, and I think I found something more. I use the xwiki without any change about encoding, just using default encoding ISO-8859-1. Use Jetty and HsqlDB. I write Chinese twice. Then roll back. The words can display correctly. But the only problem is that if I use Wiki text editor, I found that Chinese characters show like %D6%D0%CE%C4. It's can work in both view and roll-back. Therefore, I think the charaters can saved correctly in the database using ISO-8859-1. And it gose alone well with the WYSIWYG editor. But it's not convenient at all as I can't see any Chinese. So I think the ISO-8859-1 can't display Chinese characters in xwiki editor. But if I instead ISO-8859-1 with UTF-8 int the web.xml xwiki.cfg and velocity.properties. Roll-back problem came again. But Chinese show properly int xwiki ext editor. Hope to help some. Thanks, Sincerely, Wang Ning 2007/3/17, jimmy(a)comkraft.com < jimmy(a)comkraft.com&gt;gt;: I tried to creat/modify a couple of pages in Chinese and I didn't see any problems when rolling back. I tried to use both the WYSIWYG editor and the wiki editor but both seems to work for me. I am using 1 Beta 4 on a Windows 2000 computer Sp4 (locale is English). The database is PostgreSQL 8.2.3 I use UTF-8 for the DBs but didn't change any other settings. I am using the following tool to input Chinese (http://www.3d114.com/tools/gb_pinyin.htm ) and then paste them into my xwiki. You may want to try putting in Chinese there and paste them into your wiki to see if there are some other encoding issues in the input phase - as there are several internal formats for Chinese Characters (Big5, GBxxxx, UTF-8 etc). Hope this helps.Bonjour, J'ai parfaitement compris votre explication. Je vous remercie. Cordialement. -Jimmy even when though, but characters are internal. created encoding current chars of the parameter are called using little when discussion don't know disk are UTF-8 or roll shell, I've variables either file, property> -- You receive this message as a subscriber of the xwiki- users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto: sympa(a)objectweb.org?subject=help ObjectWeb mailing lists service home page: http:// www.objectweb.org/wws -- You receive this message as a subscriber of the xwiki- users(a)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 -- You receive this message as a subscriber of the xwiki- users(a)objectweb.org mailing list. To unsubscribe: mailto: xwiki-users-unsubscribe(a)objectweb.org For general help: mailto: sympa(a)objectweb.org?subject=help ObjectWeb mailing lists service home page: http:// www.objectweb.org/wws -- You receive this message as a subscriber of the xwiki- users(a)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