Search code examples
mysqlutf-8utf8mb4

What is in utf8mb4 that is not in utf8 in MySQL?


Can't seem to find any resources online that state what languages/characters are in MySQL's utf8mb4 (4 byte utf8) that are not in utf8 (3 byte UTF8).

Can someone please explain what additional language/character support comes with utf8mb4?


Solution

  • According to here, here and here all characters that were outside the Basic Multilinguan Plane were truncated with the old utf8 type in MySQL.

    Basically with utf8mb4 you should be able to support even the Supplementary Multilingual Plane and even what's further.