characterEncoding

open nano /opt/openfire/conf/openfire.xml search string jdbc:mysql://127.0.0.1:3306/openfire edit jdbc:mysql://127.0.0.1:3306/openfire?characterEncoding=UTF-8 /etc/init.d/openfire restart