Re: Help explain character_set_database and collation_database
Posted by: Bernt Marius Johnsen
Date: August 22, 2019 04:08AM


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 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.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.