CODEWITHSUNDEEP
mysqldatabasecharacter-encoding
dwjv
dwjv

Reputation: 1227

MySQL character set and collation

Ok, quick question regarding charset/collation.

If I have a database where the collation_database=latin1_swedish_ci but all the tables and columns have been created using utf8 will it differ from a database that has collation_database=utf8_general_ci with the same tables/columns? (I realise that creating new tables will pick up latin1 unless specified).

Am I right in thinking that collation_database (and character_set_database) are only defaults and they can just be overridden on table creation?

Cheers, Dave

Upvotes: 1

Views: 182

Answers (1)

deceze
deceze

Reputation: 522626

Yes, they are only defaults. The columns are the things that have an encoding in MySQL. If you do not specify an encoding for a column, the next higher default applies (table encoding, database encoding, server encoding). That's all.

Upvotes: 2

Related Questions