Openfire 3.5.2 can't support Chinese chat log?

I build a openfire server on Ubuntu 8.04 server!

but ‘Archiving’ module can’t display Chinese , some ‘???’ on the chat log.

How can I fix it ? Thank you.

example:

Are you sure Ubuntu or the browser you’re using has chinese-font support currently setup and enabled?

Hi,

are the characters stored properly in the database? Are you using MySQL?

You may want to change the font which is used to display the logs, maybe the used font does not contain these characters.

LG

yes! I sure my browser is chinese interface and support all chinese-font!

next step I can do someting to do?

thx!

Hi,

I using MySQL!

  • Open file /path_to_your_database/db.opt and change value to Chinese charset. Including two properties

default-character-set=???

default-collation=???

??? is your charset

  • Restart your mysql

Hope this help.

my god!

I can’t search the ‘db.opt’ file name on my server ?

tell me why?

but my server installed PHPMYADMIN , how can I do?

FYI

Try with path /var/lib/mysql

or

login mysql command and type show variables;

You can change charset value at phpMyAdmin for each database, tables and fields

Hi,

did you add ?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8 to your openfire.xml file as described in http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html ?

LG