Emails with "new smiley" (emoji) not archived - error

Hi Kristjan Geir Mathiesen 

Can you kindly provide full failed query and all related sugarcrm.log entries as well?

Hello Kristjan Geir Mathiesen,

Basically 'utf8_general_ci' collation do not support this type of special characters and throws Incorrect string value error in sql query execution.  You can resolve this issue by changing the field collation to "utf8mb4_general_ci" .

Please execute below query in your database and check.

ALTER TABLE `emails_text` CHANGE `description_html` `description_html` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;

Hope this will helps you.

Thanks for the suggestion, Maulik Shah This didn´t work though  I´ll just open a ticket with support.

Thanks for the suggestion, Maulik Shah This didn´t work though  I´ll just open a ticket with support.