4 ms·
Collation is both. It combines both the locale-specific sorting approach, and the encoding.
by TazeTSchnitzel 12y ago
Collation 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.