Please find here preserved knowledge that does not (yet) deserves its own page or is interdisciplanry so that it would fit in more that one place. This includes topics like...
Charset and Collation Recommendation for MySQL/MariaDB
[client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] character-set-client-handshake = FALSE collation-server = utf8mb4_unicode_ci init-connect = 'SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci' character-set-server = utf8mb4
Further Reading / Sources:
- utf8 vs. utf8mb4
- MariaDB KB article on Setting Character Sets and Collactions
- How to support full Unicode in MySQL databases by Mathias Bynens