Emails template data with strange characters

[asmecher]

Hi @nuno,

Can you post those settings here? Specifically, connection_charset, database_charset, and charset_normalization. Recommended values are in this thread:

Migration from OJS-2.3.7PJS to OJS-2.4.7.1 french not migrating

Hi @an75824, Ideally these settings should be… client_charset = utf-8 connection_charset = utf8 database_charset = utf8 charset_normalization = Off If you already have content in your database that’s not properly UTF-8 encoded, you may need to transcode your database. You can do this by running a mysqldump through a transcoder like iconv and then loading the result back in to MySQL. Regards, Alec Smecher Public Knowledge Project Team

Check using your browser’s “View Page Info” tool to see that the page is in the UTF-8 encoding. If you’ve inadvertently added whitespace to the header template or something similar, even though the page will specify UTF-8, the browser will interpret it as Latin1 or similar.

If you did a database dump and reload, it’s possible that the encoding got garbled there; on some versions of MySQL it’s necessary to specify --default-character-set=utf8 to mysqldump.

Regards,
Alec Smecher
Public Knowledge Project Team