JForum2.1.6 chinese charactset problem

[Migrated From Jforum.net]

Tomcat 5.0.28,mysql 5.0.18 on RHEL AS3 ,The topci title no problem,but can not show the topic correct. there are "??".The database charact set is UTF-8.

and I changed the WEB-INF/config/SystemGloblals set the encoding parameter to GB2312 but it not work. The problem is still.

How can I fix this problem.
[originally posted on jforum.net by northwindrocker]

[Migrated From Jforum.net]

and preview the topic is correct.but it's wrong after it submit.
[originally posted on jforum.net by northwindrocker]

[Migrated From Jforum.net]

Try chanding the database encoding as well. (web-inf/config/database/mysql/mysql.properties)

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

hi Rafael ,there are two encoding in WEB-INF/config/database/mysql/mysql.properties

are 'dbencoding' and 'mysql.encoding' which one should I change,and should change it to what value?

THX
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Let's try first with UTF-8:

Change dbencoding to UTF-8, as well the "encoding" key in SystemGlobals.properties (take a look at jforum-custom.conf as well).

Make sure "dbunicode" is "true".

Test. If it doesn't work, try setting all encodings to GB2312, and a mix of "dbunicode" to "true" or "false".

Sometimes it can be hard to find the right configuration, because the OS encoding may interfer on the process.

Rafael
[originally posted on jforum.net by Rafael Steil]