I have recently set up jforum (2.1.6) in my machine.
But, I am not being able to send posts which has Kannada (utf-8) text. The Kannada text will be converted to question marks ??? when I view my message after posting.
I have MySQL 5.0.18 (supports unicode). I have selected UTF-8 as Character Encoding for JForum (in jforum installation page) . But, somehow all the tables in jforum database had latin1 set as charset. Then, I changed all of them to UTF8.
But, still I am not being able to use Unicode in my jforum.
Please help me.
Siddharudh P T [originally posted on jforum.net by siddharudh]
Get file <Tomcat dir>/webapps/<JForum app>/WEB-INF/config/database/mysql/mysql_db_struct.sql
Add in all "CREATE TABLE" "DEFAULT CHARSET=utf8".
And run this script on ur database. It will REMOVE all ur old forum data.
Then run <Tomcat dir>/webapps/<JForum app>/WEB-INF/config/database/mysql/mysql_data_dump.sql [originally posted on jforum.net by VVD]