3 ms·
The authors actual understanding of MySQLs encoding is only half way there. Collation specifically is the algorithm it will use when ordering by the column for
by donatj 12y ago
The authors actual understanding of MySQLs encoding is only half way there. Collation specifically is the algorithm it will use when ordering by the column for instance.
The article contains numerous half truths and generalizations (the kind someone in the process of learning would say) and not expertise.
Take what he says with a grain of salt.
- TazeTSchnitzel 12y agoCollation is both. It combines both the locale-specific sorting approach, and the encoding.
- donatj 12y agoCollations are encoding specific, eg: utf_general_ci works specifically on UTF8 values, that said, the collation does not determine the encoding, the encoding determines the potential collations.
- TazeTSchnitzel 12y agoBut the collation field specifies both the collation and the encoding?
- donatj 12y agoCREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]] Character set is specified separately from collation. It's like having a ford vs a ford headlight. The collation is a part of the character set.