Can not display Chinese Char in Post Subject and Message body

[Migrated From Jforum.net]

Dear Jforum friends:

I met a strange problem on displaying Chinese Char:

Server-Condition: (Successfully installed Jforum)
jforum-2.1.7-b3.zip
jakarta-tomcat-5.0.28
jdk-6u2-solaris-sparcv9
mysql-5.0.45-solaris10-sparc-64bit

Problem:
1. Can not not display Chinese Char in Post Subject and Message body.
Check mySQL DB table: jforum_posts_text, the post_text, and post_subject fields contains "??", which are supposed to be Chinese char

2. I have DB table option: InnoDB, utf8 and utf8_general_ci

3. The jforum_topics table has the same setting, but I could see the topic title in Chinese on the display page.

Your help will be greatly appreciated.

Richard


[originally posted on jforum.net by richardzhou2005]

[Migrated From Jforum.net]

Dear admin:

I am blocked by this issue, frustrate. Your help will be greatly appreciated.



Richard

[Test] [Chinese: ??] [Englist: Thank You]

richardzhou2005 wrote:Dear Jforum friends:

I met a strange problem on displaying Chinese Char:

Server-Condition: (Successfully installed Jforum)
jforum-2.1.7-b3.zip
jakarta-tomcat-5.0.28
jdk-6u2-solaris-sparcv9
mysql-5.0.45-solaris10-sparc-64bit

Problem:
1. Can not not display Chinese Char in Post Subject and Message body.
Check mySQL DB table: jforum_posts_text, the post_text, and post_subject fields contains "??", which are supposed to be Chinese char

2. I have DB table option: InnoDB, utf8 and utf8_general_ci

3. The jforum_topics table has the same setting, but I could see the topic title in Chinese on the display page.

Your help will be greatly appreciated.

Richard

[originally posted on jforum.net by richardzhou2005]

[Migrated From Jforum.net]

check your jforum-custom.conf, and modify the setting as follows:

mysql.encoding=&characterEncoding\=utf8   
mysql.unicode=&useUnicode\=true

See if this works.

http://www.andowson.com/posts/list/3.page

[originally posted on jforum.net by andowson]