当前位置: article > 正文

mysql 8中utf8和utf8mb4运行时的编码告警提醒_[warning] [my-013242] [server] --character-set-ser

作者：我家小花儿 | 2024-06-15 00:32:50

踩

[warning] [my-013242] [server] --character-set-server: 'utf8' is currently a


2020-01-14T21:14:26.516484Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2020-01-14T21:14:26.516496Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.

'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release

解决方案

修改my.cnf文件

把mysql字符集和排序规则改一下


# 指定编码 utf8mb4
character-set-server=utf8mb4
 
# utf8mb4的排序规则
collation-server=utf8mb4_0900_ai_ci

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家小花儿/article/detail/720183