AnsweredAssumed Answered

Can we store Emoji's in a MySQL DB?

Question asked by Jeff Bickart on Nov 7, 2015
Latest reply on Apr 26, 2019 by sugar.dennis

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