Email Not Received When Body Contains Specific Emoji

[sspro]

We are unable to receive emails when the body of the message contains the 'hands pressed together' emoji ?

We have tested with other emojis in the subject and in the email body and these ARE received. Specifically the 'sparkles' emoji ✨ this emoji has no problem.

What could be causing emails with specific emojis in the body to not be received? Thank you.

Docker Compose:
EspoCRM version: 7.4.5
MYSQL 8
PHP 8.1.19 (cli) (built: May 13 2023 00:41:40) (NTS)


[2023-06-15 15:54:06] ERROR: InboundEmail 6474d09580779dc99, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\xB3' for column 'name' at row 1
[2023-06-15 15:57:14] ERROR: InboundEmail 64737ee2b1ed3d3b2, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x99\x8F\xF0\x9F...' for column 'body_plain' at row 1
[2023-06-15 16:06:11] ERROR: InboundEmail 6474d09580779dc99, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\xB3' for column 'name' at row 1
[2023-06-15 16:13:06] ERROR: InboundEmail 646526b1966ac628d, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x99\x8F\x0D\x0A' for column 'body_plain' at row 1
[2023-06-15 16:15:06] ERROR: InboundEmail 6474d09580779dc99, import message; HY000 SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x98\xB3' for column 'name' at row 1

Email Table Screenshot attached.

[esforim]

Interest, possible bug here.

Have you manage to reproduce it on the demo?

[yuri]

Solution here: https://forum.espocrm.com/forum/gene...smilie-in-text

[esforim]

Looking at timeframe, you might want to update:

https://github.com/espocrm/espocrm/issues/2781