mysql note

最新推荐文章于 2025-06-12 09:35:02 发布

zyt_coder

最新推荐文章于 2025-06-12 09:35:02 发布

阅读量498

点赞数 1

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/Lucky_boy_gilr/article/details/78059484

版权

mysql 专栏收录该内容

4 篇文章

订阅专栏

查看mysql字符编码集

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

修改相应的字符集

msql> ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

msql> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

msql> ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;