BestHub
Sign in
Tag

database encoding

0 views collected around this technical thread.

Laravel Tech Community
Laravel Tech Community
Nov 22, 2021 · Databases

Understanding MySQL utf8 vs utf8mb4: Handling Emoji and Unicode Characters

This article explains why inserting emoji into MySQL fails with the default utf8 charset, demonstrates how switching to utf8mb4 resolves the issue, and provides a historical overview of MySQL's limited utf8 implementation and the proper use of true UTF‑8 encoding.

MySQLUnicodecharacter set
0 likes · 7 min read
Understanding MySQL utf8 vs utf8mb4: Handling Emoji and Unicode Characters
macrozheng
macrozheng
Aug 20, 2020 · Databases

Why MySQL’s utf8 Isn’t Real UTF‑8 and How utf8mb4 Fixes Emoji Errors

The article explains why MySQL’s built‑in utf8 charset only supports up to three‑byte characters, causing insert errors with four‑byte emojis, and shows how switching tables, system, and connection settings to utf8mb4 resolves the issue while detailing the historical reasons behind this limitation.

MySQLcharacter setdatabase encoding
0 likes · 9 min read
Why MySQL’s utf8 Isn’t Real UTF‑8 and How utf8mb4 Fixes Emoji Errors