Help!!!Why can't it display chinese in topic.description?

Jul 10, 2012 at 10:25 AM

Chinese in the titles and the tags are correct,but the content of the topic always be"?????".

I use MySQL Database。。。。

Coordinator
Jul 10, 2012 at 11:01 AM

Hi,

What version of Nearforums are you using? If you use the latest version (V8), you should be able to post UTF-8 strings...

The topics.description column and the param type is LONGTEXT that is dependant on shema / table collation: What is your schema collation?

 

Kind regards,

Jorge

 

Jul 11, 2012 at 9:18 AM

I‘m sure that i'm using v8, and the database, all table charset is utf-8. Yesterday I changed the type from longtext to varchar(21000) and it could display Chinese now.  But i think this could only be a temporary solution. And when I write Chinese in database directly by using phpMyAdmin, the Chinese can display correct...

Coordinator
Jul 11, 2012 at 9:38 AM

Hi,

Check your collation and character sets variables, using these 2 queries:

SHOW VARIABLES LIKE 'char%';

SHOW  VARIABLES LIKE 'collation_%';

 

Also, try to specify the character set in the connection string: http://www.connectionstrings.com/mysql#p0cs12

 

Hope it helps,

Kind Regards,

Jorge

Jul 12, 2012 at 4:34 AM

hi,

Thank you very much, it works now.

NF is a really good forum. 

 

Kind Regards,

tyk5555

Jul 12, 2012 at 4:43 AM

hi,

Thank you very much, it works now.

NF is a really good forum. 

 

Kind Regards,

tyk5555