unicode problem!

[Migrated From Jforum.net]

Hello,

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.

Thanks,
Siddharudh P T
[originally posted on jforum.net by siddharudh]

[Migrated From Jforum.net]

Get file <Tomcat dir>/webapps/<JForum app>/WEB-INF/config/database/mysql/mysql_db_struct.sql

Add in all "CREATE TABLE" "DEFAULT CHARSET=utf8".

DROP TABLE IF EXISTS jforum_banlist;
CREATE TABLE jforum_banlist (
  banlist_id INT NOT NULL auto_increment,
  user_id INT NOT NULL default '0',
  banlist_ip varchar(8) NOT NULL default '',
  banlist_email varchar(255) default NULL,
  PRIMARY KEY  (banlist_id),
  INDEX idx_user (user_id)
) TYPE=InnoDB 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]

[Migrated From Jforum.net]

Thanks for the reply.

Actually, it was my mistake! I forgot to set MySQL env variable "character_set_server" to utf8 (it was latin1 by default).

Now, I am being able to use Kannada text in JForum discussions :-)

Thanks,
Siddharudh
[originally posted on jforum.net by siddharudh]