Arch Linux

Description: I've just reported a bug about emojis not displaying properly in Chromium and got an error when I hit "Add this task". I've encountered this error years ago myself and know what the root cause is. Arch's install of Flyspray backend probably uses MySQL (or one of the forks) and tables were specified as utf8. That's bad because utf8 in MySQL is not really utf8 and MySQL devs cheated and reduced the amount of bytes that you can use (only 3 instead of 4 bytes). To get proper utf8 support so all characters can be properly stored, use utf8mb4 which is the true utf8 format. That's why these weird errors pop up.

Error:

Query {INSERT INTO `flyspray_tasks` ( task_id, date_opened, last_edited_time, project_id, item_summary, detailed_desc, opened_by, percent_complete, task_type, item_status, product_category, product_version, closedby_version, operating_system, task_severity, task_priority, mark_private, due_date, closure_comment, anon_email ) VALUES .... Failed! (Incorrect string value: '\xF0\x9F\x8D\x94\x0D\x0A...' for column 'detailed_desc' at row 1)


Additional info:
N/A


Steps to reproduce:
Paste an emoji and hit "Add this task" or just comment with an emoji.