We are doing what you want and are actually using the translation feature (it's fantastic, use it!). I want to write a wiki page for it, but didn't have time yet.
We use English, German and Chinese for our website. Database is MySQL. Charset is "gbk".
(1) Set the charset for the database in override/site.ini.append.php: Charset=gbk in [DatabaseSettings]
(2) Set the charset in override/i18.ini.append.php: Charset=gbk in [CharacterSettings] (3) Set the charset in the language locale file that you use right. In chi-CN.ini (file: share/locale/chi-CN.ini) or in eng-GB.ini (file:share/locale/eng-GB.ini): Preferred=gbk in [Charset].
I think that's all.
It works for us *except* the input fields in the admin section. I have to look into that because I think the charset for the textfields are not set right (is that how it works?). But you can copy/paste Chinese characters in it that works.
Most important is the right charset for the database.
Great! It works with the GBK char set (Simplified Chinese).
Since Traditional Chinese is my goal, I tried replacing all the "gbk"s with "big5"s in those 3 setup files. However, this didn't work as well: Instead of "charset=big5", the HTML sources produced have "charset=cp850", which causes IE to switch to a DOS char set.
If you want to use utf-8 unicode at the moment you have to options
1. Use postgreSQL 7.3.2 (http://www.postgresql.org/news.php?NewsID=128) 2. Wait for mySQL 4.1 (http://www.mysql.com/doc/en/News-4.1.x.html) as this supports unicode. It is currently in Alpa release but it might have what you need if you are not going prime time right now.
I hope this helps
tony
Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development
The charset big5 is definitely the right one for mySQL, so this setting is ok (and I think there is no other charset for simpl. Chinese in mySQL).
eZp seems to change big5 to cp850 somewhere, but don't ask me where (it does some charset conversions so I guess the problem lies there). Try some other charsets in the i18n.ini or site.ini, maybe that helps.
unfortunately my host only sports mysql version 4.0, so no native unicode support yet. so i try to settle with any other character set that works with mysql 4.0 and php 4.3.2 to display and store chinese characters.
any recommendations from your side? i haven't really worked out on how to "alter database" to another character set like GBK.
regards!
You must be logged in to post messages in this topic!