Re: Help explain character_set_database and collation_database

[Gary Yang]

I still think they are information only, which don't affect anything. What are really in effect are the default character set and default collation of the database, not the values the variables.

Example:

use fiscal;
show variables like 'collation_database%'; -- ==> latin1_general_cs
set collation_database=latin1_general_ci;
show variables like 'collation_database%'; -- ==> latin1_general_ci
create table t1 (co11 char (1));

Table t1 is effectively created as:

CREATE TABLE `t1` (
`co11` char(1) COLLATE latin1_general_cs DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;