Hm. Dieser Kommentar in der bei mir vorliegenden Datei /etc/mariadb.conf.d/50-server.cnf ist wohl nicht ganz richtig:
#
# * Character sets
#
# MySQL/MariaDB default is Latin1, but in Debian we rather default to the full
# utf8 4-byte character set. See also client.cnf
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
denn (Zitate)
MySQL Server has a server character set and a server collation. By default, these are utf8mb4 and utf8mb4_0900_ai_ci , but they can be set explicitly at server startup on the command line or in an option file and changed at runtime.
https://dev.mysql.com/doc/refman/8.0/en/charset-server.html
und
In MariaDB, the default character set is latin1, and the default collation is latin1_swedish_ci (however this may differ in some distros, see for example Differences in MariaDB in Debian).
https://mariadb.com/kb/en/character-set-and-collation-overview/
Und welche Datenbasis ist da Default?
Zitate:
InnoDB is a good general transaction storage engine, and, from MariaDB 10.2, the best choice in most cases. It is the default storage engine from MariaDB 10.2.
https://mariadb.com/kb/en/choosing-the-right-storage-engine/
und
The default engine is InnoDB in MySQL 8.0.
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
Was ich mich gerade frage: Google liefert diese Seiten an erster Stelle wenn man nach „mysql“ oder „mariadb“ und „character set“ bzw. „default engine“ sucht... Warum also spekulieren?