MySQL utf8mb4, Errors when saving Emojis

character_set_client, _connection, and _results must all be utf8mb4 for that shortcake to be eatable.

Something, somewhere, is setting a subset of those individually. Rummage through my.cnf and phpmyadmin’s settings — something is not setting all three.

If SET NAMES utf8mb4 is executed, all three set correctly.

The sun shone because it is only 3-bytes – E2 98 80; utf8 is sufficient for 3-byte utf8 encodings of Unicode characters.

Leave a Comment

tech