MySQL 设置默认字符编码的排序
步骤
添加到 /etc/mysql/mysql.conf.d/mysqld.cnf
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
systemctl restart mysql
验证 SHOW VARIABLES LIKE ‘collation_%’;
区别
- ci 大小写不分区
- si 大小写区分
- utf8mb4_general_ci
- 不区分 A, a, À, å 等,排序和比较快一点
- utf8mb4_unicode_ci
- Unicode 排序规则,区分 A, a, À, å 等,慢一点
推荐文章: