Galette

On MySQL and MariaDB utf8 is an alias for utf8mb3 - which uses 3 bytes for character storage. utf8mb4 uses 4 bytes, and therefore, can store many much characters.

While this is not an issue most of the time, it could be for some languages, emoticons, etc. On that page: https://codepoints.net/planes, only the "Basic Multilingual Plane" is handled by utf8mb3.

You will certainly be very, very happy to known that Galette will be able to store all those useful characters:

• https://codepoints.net/supplemental_symbols_and_pictographs
• https://codepoints.net/chess_symbols
• https://codepoints.net/symbols_and_pictographs_extended-a
• https://codepoints.net/emoticons

Note that PostgreSQL does not need any further migration; everything is already working as expected.