Re: Help explain character_set_database and collation_database

[Bernt Marius Johnsen]

Hi,

In mysql 5.7 and mysql 8.0, changing character_set_database/collation_database has no effect on CREATE TABLE. The defaults for the table is inherited from the schema (Use SHOW CREATE SCHEMA to see how the schema is defined).

However, the variables have impact on LOAD DATA INFILE. See https://dev.mysql.com/doc/refman/8.0/en/load-data.html for details.

PS: I prefer the term "schema" instead of "database" since "schema" is according to the SQL standard and "database" may in some contexts be misleading. In MySQL "schema" and "database" is synonymous.