Details
Description
Adding an emoji(common when using mobile devices) that uses 4 bytes in the editor does not work. Behaviour differs from tool to tool. For example in Lessons tool when pasting the "grinning face with smiling eyes" from http://apps.timwhitlock.info/emoji/tables/unicode in to the editor user will be presented with the error:
Unable to save or update item. Error was: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x81</...' for column 'html' at row 1
The correct solution to this is to convert from utf8 to utf8mb4(https://mathiasbynens.be/notes/mysql-utf8mb4).
Please feel free to edit to change to the correct components, I am not sure how to label this issue.