[xwiki-users] Xwiki encoding for french language
Hello everyone, I recently tried to insert french language characters (é, è, à) in xwiki.atc.ch for: 1. Validation Email content 2. Confirmation Email content (under Home>Administer Wiki>Users and Groups>Registration) but when we register, we get the above mentioned characters as "?" in the email. I changed encoding to UTF-8 for xwiki encoding and html encoding (as per http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Encoding) and reloaded tomcat6 and apache, but it still displays "?" characters in the email received. Anyone have an idea of how to proceed please? *also, I found http://lists.xwiki.org/pipermail/users/2007-March/002944.html - saying to change mysql encoding (which I didn't perform till now), is it recommended? (other apps/websites are running on the same server) Thanking you in advance, Regards, Mike Migale Mike Migale Solero Royal Road, Moka 80829 T: +230 650 8880 E: [email protected]
On Thu, Nov 20, 2014 at 9:15 AM, Mike Migale <[email protected]> wrote:
Hello everyone,
I recently tried to insert french language characters (é, è, à) in xwiki.atc.ch for: 1. Validation Email content 2. Confirmation Email content (under Home>Administer Wiki>Users and Groups>Registration)
but when we register, we get the above mentioned characters as "?" in the email. I changed encoding to UTF-8 for xwiki encoding and html encoding (as per http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Encoding) and reloaded tomcat6 and apache, but it still displays "?" characters in the email received. Anyone have an idea of how to proceed please?
*also, I found http://lists.xwiki.org/pipermail/users/2007-March/002944.html - saying to change mysql encoding (which I didn't perform till now), is it recommended? (other apps/websites are running on the same server)
The database containing XWiki need to use utf8_bin MySQL encoding, you don't need to change MySQL server default encoding. But it's not just a configuration, you have to convert the existing tables, see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL and more specifically http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HTips.
Thanking you in advance,
Regards, Mike Migale
Mike Migale
Solero Royal Road, Moka 80829 T: +230 650 8880 E: [email protected] _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
Once that database is adjusted, you can even get URLs with accents which is rather cool I feel.
The database containing XWiki need to use utf8_bin MySQL encoding, you don't need to change MySQL server default encoding. But it's not just a configuration, you have to convert the existing tables, see http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HTips.
(note that this process does not prevent other databases to run, but I would do this only after switching all clients on that precise DB; make sure to backup the DB in SQL first, my experience is that case insensitive file systems may be a problem) paul
participants (3)
-
Mike Migale -
Paul Libbrecht -
Thomas Mortagne