Warum fragen und spekulieren?
bearbeitet von RaketenwilliHm. Dieser Kommentar in der bei mir vorliegenden Datei /etc/mariadb.conf.d/50-server.cnf ist wohl nicht ganz richtig:
~~~conf
#
# * 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?**
Zitat:
> 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/>
> 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?
Warum fragen und spekulieren?
bearbeitet von RaketenwilliHm Dieser Kommentar in der bei mir vorliegenden Datei /etc/mariadb.conf.d/50-server.cnf ist wohl nicht ganz richtig:
~~~conf
#
# * 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?**
Zitat:
> 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/>
> 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?
Zeilenumbruch in mysql-DB eintragen
bearbeitet von RaketenwilliHm Dieser Kommentar in der bei mir vorliegenden Datei /etc/mariadb.conf.d/50-server.cnf ist wohl nicht ganz richtig:
~~~conf
#
# * 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?**
Zitat:
> 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/>
> 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?
Zeilenumbruch in mysql-DB eintragen
bearbeitet von RaketenwilliHm Dieser Kommentar in der bei mir vorliegenden Datei /etc/mariadb.conf.d/50-server.cnf ist wohl nicht ganz richtig:
~~~conf
#
# * 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?**
Zitat:
> 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/>
> 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...