AnsweredAssumed Answered

Can we store Emoji's in a MySQL DB?

Question asked by Jeff Bickart on Nov 7, 2015
Latest reply on Jun 22, 2017 by Kristjan Geir Mathiesen

It's an EMOJI society... We have the need to store emoji's in the DB. On the backend; we can change the collation for a table from utf8_general_ci to utf8mb4_general_ci and update the columns to be utf8mb4_general_ci.

 

We are able to insert the emoji via PhpMyAdmin but inside of Sugar we are unable to save or view the emoji. The information is viewed correctly in PhpMyAdmin

 

Any idea?

 

The error is when inserting is from sugar is

MySQL error 1366: Incorrect string value: '\xF0\x9F\x8F\x88To...' for column 'description' at row

 

 

Outcomes