Cannot use chinese.

[Migrated From Jforum.net]

Hi, I'm from HK and want to use traditional chinese in my forum. My forum could display in traditional chinese after the installation. But for those chinese posts or reply i add to the forum, it could only display as "???".

As I read through the threads about chinese in this forum, I realized that I may need to do the following changes:

WEB-INF\config\database\mysql\mysql.properties
dbencoding=big-5 (originally utf8)

WEB-INF\config\jforum-custom.conf
dbencoding=big-5 (originally utf8)

WEB-INF\config\SystemGlobals.properties
encoding=BIG5 (originally UTF-8)

But changing UTF-8 to BIG-5 does not help any. Using UTF-8 and BIG-5, both give me "???". Help......


Here is the variables for my mysql server.
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_results utf8
character_set_server latin1
character_set_system utf8
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server latin1_swedish_ci

Anyone have successful experience, please share it. Thousands of thanks.
[originally posted on jforum.net by viviancpy]