Offline message only support english and number?

Openfire Openfire Support
1

Hello, I use openfire and test offline message. But I test offline message only show english or number text. If I type chinese font is no show. My client is use spark. Could not support it?

2

Offline messages are stored in the database, so your database has to support this charset. I think you have to use UTF for database, but i don’t know the specifics. Also, what version of Openfire?

3

I use openfire 4.4.0. How to check my database?

4

Are you using embedded database or external like MySQL?

5

I use Mysql.

6

I don’t have much experience with MySQL. There should be a config file where you can set the encoding. Or maybe this has to be done to the table itself. Google about enabling utf in mysql.

7

Hello,
I found it’s will write to mysql if english or number.But chinese NOT write to database. If not support it’s should show unknow code. But it’s not write to database.

8

I’m not using mysql, but I suppose you should add something like “useUnicode=true&characterEncoding=UTF-8” to your connectionstring.

1 Like