A little background: I am migrating from an embedded db on WinXP to mysql db on Ubuntu 10.
The migration is almost complete, but I have one issue with the chinese characters that were stored in the message archive under the embedded db. They now appear in their unicode (I believe) format when I view the message archive. I have added UTF8 support to mysql via http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html#postgres and also set the default character set to UTF8 when I first created the openfire database in mysql.
Has anyone successfully migrated an embedded db to mysql that has chinese characters? If so am I missing some step in the migration process?