Forums | Mahara Community
Text containing emojis are not accepted in Mahara MySQL DB
02 September 2017, 6:52 AM
When we try to insert a text containing special characters like emoticons, the message is saved but truncated from the special character.
For example: "Some characters, like '𝑅' or emoticons '😊', produce the error."
it is reduced to: "Some characters, like '
There is the same issue in Moodle and we are migrating our databases from utf8 to utf8mb4 to solve the problem (they have created one script to migrate the database).
Does anyone have already migrated the Mahara database? Any feedback about this issue would be really appreciated.
Our environment: Mahara 16.10, MySQL 5.6
Thanks in advance, best regards.
05 September 2017, 9:47 AM
Thank you for reporting this, I could replicate the same error with MySQL. We have made a bug report to follow ths issue. When we have a patch that ensures Mahara is ready to handle utf8mb4, we will update that report.
You can follow the progress here