流沙团
[mysql]1267 - Illegal mix of collations
2021-9-7 流沙团


字符集排序的问题


SET collation_connection = 'utf8mb4_general_ci';

ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
发表评论:
昵称

邮件地址 (选填)

个人主页 (选填)

内容