AnsweredAssumed Answered

Unable to Insert Emoji's to MySQL Database using Boomi

Question asked by ksandu123 on Oct 5, 2017
Latest reply on Oct 6, 2017 by Adam Arrowsmith

Hi,

 

We are passing the survey comments in a field and inserting the record to MySql database. When the user enters emoji's , we are getting an error and unable to proceed further. The error says :

Incorrect string value: '\xF0\x9F\x8C\xB9' for column 'agent_survey_comments' at row 1

 

UTF-8 is enabled at Molecule level, column level ,table level at Database. I have used the base 64 Encoding too. 

Outcomes