Inbound email body contains utf8 hex code instead of real char (e.g. à = =C3=A0; è = =C3=A8)

[Sasamous]

Issue

When I receive mails with special character like (à, è, ì, ò, ù,) or just characters like "=", special chars are translated in hex code instead of normal text.
Cases created with mails get wrong text in DB too, Cases created with Joomla AOP are stored correctly.

Steps to Reproduce

1. Clean install or SuiteCRM 7.11.8

2. Setup of mail and "Create case from mail"

3. Get mails

Context

Your Environment

• SuiteCRM Version used: 7.11.8
• Browser name and version: anyone
• Environment name and version: MariaDB, PHP 7.2
• Operating System and version: Ubuntu 18.04

[Mac-Rae]

I think it is a known issue across the CRM, Might be related to #3192

@Dillon-Brown What's your opinion on this one?

[Sasamous]

@Mac-Rae The strange is the problem appears only in email body, if I send and email with special chars in subject, it is correct, everywhere in SuiteCRM special chars are accepted, the problem is only in emails body

[Dillon-Brown]

@Mac-Rae This definitely shouldn't be a known issue anymore, I had created a new field type "EmailBody" to handle this. I'll take a look at this and see if I can replicate when I get a chance, thanks.

[Dillon-Brown]

Confirmed, this will be fixed for the next release. Thanks for the report!

[Laszlo-Gaessler]

We updated our CRM to version 7.11.9 and newly imported emails are displayed in the correct way again.
Old emails, that have been imported to the database before the update, however, are still being displayed in the “unreadable” way. Is there an option to fix the display of these old emails as well? If so, how?

[Dillon-Brown]

Old emails, that have been imported to the database before the update, however, are still being displayed in the “unreadable” way. Is there an option to fix the display of these old emails as well? If so, how?

Hi @Laszlo-Gaessler, unfortunately if you've already imported the email there's no way to fix the display since it will already be physically in the database.