Not all Unicode chars supported in quiz question text

In Create question for a question set, I tried setting the following text: Will have no answers 😃

I got the following in a bottom right popup toast:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF0\x9F\x98\x83' for column `tms_dev`.`quiz_questions`.`text` at row 1 The SQL being executed was: INSERT INTO `quiz_questions` (`text`, `questionsetID`, `questionNumber`) VALUES ('Will have no answers 😃', 2, 1)

This is wrong for at least the following reasons:

  • It leaks technical details. Perhaps this is only active on dev.
  • All valid Unicode characters should be supported.