Openfire: Solves the garbled Problem

After openfire is deployed, Chinese characters are garbled During User Creation and offline message sending. To solve this problem, you need to configure both openfire and MySQL.

First, on the openfire end, specify the ODBC connection string to contain? Useunicode = true & characterencoding = utf8 & charset = utf8 & charactersetresults = utf8

Then, you need to determine the encoding variables in MySQL. You can run the show variables like 'Char % 'command to view the variables. If character_set_server = Latin1, you can modify the my. CNF file and add default-character-set = utf8 in [mysqld.

Restart openfire and MySQL.

 

PS: To view UTF-8 content in the MySQL command environment, run the following command: Set names utf8;