In MySQL, never use “utf8”. Use “utf8mb4”.

Today’s bug: I tried to store a UTF-8 string in a MariaDB “utf8”-encoded database, and Rails raised a bizarre error: Incorrect string value: ‘\xF0\x9F\x98\x83 <…’ for column ‘summary’ at row 1This is a UTF-8 client and a UTF-8 server, in a UTF-8 database with a UTF-8 collation. The string, “😃 <…”, is valid UTF-8. But here’s the rub: MySQL’s “utf8” isn’t UTF-8. The “utf8” encoding only supports th