Broken charset for old messages in a chatroom after rebooting the server

Openfire Openfire Support
#1

I’‘m using Wildfire with mysql and have in the config. When there are messages (in Russian) in a chat room and I’‘m restarting Wildfire, that messages’’ chars become ‘’???’’ instead of Russian letters.

Can you please tell me: is it a bug or just a misconfiguration?

Thanks in advance!

#2

Hi,

this sounds to be a bad configuration, can you try it with the embedded database? I don’'t use Russian characters but other non-ASCII characters work fine for me using the embedded database. And also MySQL should support unicode.

LG

#3

This is the solution:

  1. Create database in utf8:

CREATE DATABASE wildfire DEFAULT CHARACTER SET utf8

  1. Convert all tables to utf8

(I did that using dump, manually changing latin1 to utf8 in the dump, and then restore)

  1. Add character encoding to connection string:

Thanks vsviridov, bani and others for their questions and answers on this issue.

Message was edited by: jazzl0ver