mysql里面的COLLATE是什么意思

CREATE TABLE `table_name` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'key',
  `extra_data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'value',
  `status` tinyint(4) NOT NULL COMMENT '0:disable, 1:enable',
  `ctime` int(10) unsigned NOT NULL COMMENT 'create time',
  `mtime` int(10) unsigned NOT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

 

 

校对集，主要是对字符集之间的比较和排序，可以通过 show collation查看所有的校对集

此外可以参考下这里，官方文档说的很详细

https://dev.mysql.com/doc/refman/5.7/en/charset-binary-collations.html

https://dev.mysql.com/doc/refman/5.7/en/charset-database.html