Actions
Feature #18404
closedNew Default CharSet: utf8mb4
Start date:
15.04.2024
Due date:
% Done:
100%
Estimated time:
Discuss:
Prio Planung:
No
Vote:
Description
- Einige Tabellen sind bei uns
utf8mb3
, andereutf8mb4
- Grundsaetzlich giltin MariaDB:
utf8=utf8mb3
- Wird
utf8mb4
angegeben, wird darausutf8mb4_general_ci
- Achtung:
utf8mb3
kann keine Emoticons speichern: Allgemeine Meinung - das ist ein no go!
Links:
- https://stackoverflow.com/questions/30074492/what-is-the-difference-between-utf8mb4-and-utf8-charsets-in-mysql
- https://stackoverflow.com/questions/5567249/what-are-the-most-common-non-bmp-unicode-characters-in-actual-use
- https://dba.stackexchange.com/questions/8239/how-to-easily-convert-utf8-tables-to-utf8mb4-in-mysql-5-5
- uft8mb4 convert script: https://github.com/fleio/utf8mb4-convert/blob/main/convert.sh
- Collate
utf8mb4_unicode_ci
- https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
Actions