#charset

MySQL "Incorrect string value": store emoji and everything else with utf8mb4

Fix MySQL error 1366 "Incorrect string value: \xF0\x9F...": utf8 only holds 3 bytes, so convert the table and connection to utf8mb4, and handle index length limits.

Beginner · 4 min read