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