• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

unicode problem!

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
ice is for people that are not already cool. Chill with this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic