Mail archive not displaying special characters

Issue that can happen after version 8.6.0

Issue

In the mail archive or the view it online link we display the mail that was sent with all the dynamic content frozen when the email is sent.

To do it we have created a new table acym_mail_archive in which we save the content of the email.

On some servers, the default collation and charset of the table might be wrong even if we add it in the table creation.

The charset (character set) should be utf8 and the collation should be utf8_general_ci

With PhpMyAdmin

Connect to your PhpMyAdmin and search the table acym_mail_archive.

Then go to the Operation tab on the top and select utf8_general_ci and don't forget to check the option Change all column collations to apply the modification to all columns of the table.

With MySQL Workbench

Connect to your server with MySQL Workbench and search for the table acym_maim_archive.

Once you've found it click on the spanner icon to configure the table.

On the configuration page, you have to click on the double arrow icon in the top right corner to display the collation option. Once you've displayed it you can change the Collation to utf8 in the first select and then utf8_general_ci in the second select.

You can now click on the apply button on the bottom right corner.

Once this is done you have to verify every column (body, subject, settings, stylesheet, attachments) to the right collation if the new default one is not set.

To do it, on the same configuration page, click on every column mentioned below and change its collation settings to default.

• body

• subject

• settings

• stylesheet

• attachments

Once it's done you can click on the apply button

Once the collation is fixed on your table, you can run the following SQL query to clear the existing archive and force AcyMailing to re-generate it:

// Replace the "xxxx_" by the real table prefix or your database
DELETE FROM XXXX_acym_mail_archive WHERE 1 = 1