Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but...

最新推荐文章于 2024-06-03 00:43:14 发布
最新推荐文章于 2024-06-03 00:43:14 发布
阅读量2.1k 收藏 1
点赞数
CC 4.0 BY-SA版权
分类专栏： BUG&DEBUG 文章标签： mysql python 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/BlankGrid/article/details/104926539
在使用Python 3.6进行MySQL数据库建表时，遇到关于'utf8'字符集的警告信息，解释了该警告的原因及解决方案。指出MySQL中的'utf8'实际上仅支持UTF8MB3，而非完整的UTF-8标准，建议使用'UTF8MB4'以避免未来数据存储上的潜在问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

用Python3.6建表的时候遇到的一个警告

Warning: (3719, “‘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.”)
result = self._query(query)

这个警告还是蛮重要的，虽然不影响建表，但如果忽视可能会后续数据存储上引发问题，在一开始解决比较好。

MySQL中的所谓的utf8实际上并不是真正的UTF-8，它只支持每个字符最多三个字节UTF8MB3，而真正的UTF-8每个字符最多支持四个字节。

MySQL的解决这个问题的方法是直接发布了一个“UTF8MB4”的字符集，这个就是真正的UTF-8。

所以我们以后要想设置UTF-8时，直接用UTF8MB4即可，不要用utf8。

Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias
漫步量化
04-11 1906
问题描述 在Python使用pymysql出现如题错误： /home/data/anaconda3/lib/python3.7/site-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alia...
Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias fo
热门推荐
cuicui_ruirui的博客
05-02 1万+
pymysql执行写入mysql的操作时报错： Warning: (3719, "'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...
完美解决数据库设置字符集报错| Warning | 3719 | ‘utf8‘ is currently an alias for the character set UTF8MB3, but ...
Mortalz7
11-07 4253
| Warning | 3719 | '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. | | Warning | 3778 | 'utf8mb3_bin' is a collation of the deprecat
Zhong__ Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an
Zhong的博客
09-18 737
Yishion
Warning | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias fo...
小呆丶的博客
12-17 4750
MySQL的“utf8”实际上不是真正的UTF-8。“utf8”只支持每个字符最多三个字节，而真正的UTF-8是每个字符最多四个字节。 MySQL一直没有修复这个bug，他们在2010年发布了一个叫作“utf8mb4”的字符集，绕过了这个问题。 简单概况： MySQL的“utf8mb4”是真正的“UTF-8”。 MySQL的“utf8”是一种“专属的编码”，它能够编码的Unicod...
2023-06-05T11:35:59.033048Z 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. 2023-06-05T11:35:59.033071Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2023-06-05T11:35:59.297121Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-06-05T11:36:01.786213Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-06-05T11:36:06.009613Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
06-06
其中最值得注意的是关于字符集和校对规则的警告，MySQL 建议在未来的版本中使用 UTF8MB4 作为字符集，以避免歧义。此外，该日志还显示了 InnoDB 存储引擎的初始化过程，以及一个关于 CA 证书是自签名的警告。如果你...
2025-03-16T04:48:11.723920Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. 2025-03-16T04:48:11.741228Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2025-03-16T04:48:11.742158Z 0 [System] [MY-013169] [Server] D:\Mysql\bin\mysqld.exe (mysqld 9.2.0) initializing of server in progress as process 9208 2025-03-16T04:48:11.768998Z 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. 2025-03-16T04:48:11.818749Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-16T04:48:12.039225Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-16T04:48:13.332983Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: fIIrem7oIb.& 2025-03-16T04:48:14.410749Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end. 2025-03-16T04:55:44.566160Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2025-03-16T04:55:44.650933Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2025-03-16T04:55:44.651190Z 0 [System] [MY-010116] [Server] D:\Mysql\bin\mysqld (mysqld 9.2.0) starting as process 27044 2025-03-16T04:55:44.653855Z 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. 2025-03-16T04:55:44.703565Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-16T04:55:44.951140Z 1 [System] [MY-013577] [InnoDB] InnoDB initiali
03-17
> `[Note] InnoDB: Using utf8 tables but with the binary collation. Consider using utf8mb4 instead of utf8.` 为了兼容完整的 Unicode 表达需求并避免未来潜在问题的发生，建议执行以下更改措施： 1. 修改...
2025-03-30T05:26:36.630970Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. 2025-03-30T05:26:36.651088Z 0 [Warning] [MY-010915] [Server] &#39;NO_ZERO_DATE&#39;, &#39;NO_ZERO_IN_DATE&#39; and &#39;ERROR_FOR_DIVISION_BY_ZERO&#39; sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2025-03-30T05:26:36.651348Z 0 [System] [MY-013169] [Server] F:\mysql-9.2.0-winx64\bin\mysqld.exe (mysqld 9.2.0) initializing of server in progress as process 11812 2025-03-30T05:26:36.654113Z 0 [Warning] [MY-013242] [Server] --character-set-server: &#39;utf8&#39; 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. 2025-03-30T05:26:36.689720Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-03-30T05:26:36.981563Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-03-30T05:26:38.209156Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: =ogq_<5aWuN( 2025-03-30T05:26:39.376516Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end. 2025-03-30T05:26:52.723152Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. 2025-03-30T05:26:52.728735Z 0 [Warning] [MY-010915] [Server] &#39;NO_ZERO_DATE&#39;, &#39;NO_ZERO_IN_DATE&#39; and &#39;ERROR_FOR_DIVISION_BY_ZERO&#39; sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2025-03-30T05:26:52.728954Z 0 [System] [MY-013169] [Server] F:\mysql-9.2.0-winx64\bin\mysqld.exe (mysqld 9.2.0) initializing of server in progress as process 4424 2025-03-30T05:26:52.730538Z 0 [Warning] [MY-013242] [Server] --character-set-server: &#39;utf8&#39; 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. 2025-03-30T05:26:52.730695Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data dire
最新发布
03-31
- **原因**：MySQL 8.0+已将`utf8`标记为`utf8mb3`的别名，并计划逐步淘汰。推荐使用`utf8mb4`字符集[^2]。 - **解决方案**： 1. 修改配置文件字符集设置： ```ini [mysqld] character_set_server = utf8mb4 ...
2023-05-28T06:56:35.232970Z 0 [System] [MY-013169] [Server] D:\DB\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server in progress as process 10068 2023-05-28T06:56:35.235056Z 0 [Warning] [MY-013242] [Server] --character-set-server: &#39;utf8&#39; 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. 2023-05-28T06:56:35.237564Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2023-05-28T06:56:35.237582Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\DB\mysql-8.0.17-winx64\data\ is unusable. You can remove all files that the server added to it. 2023-05-28T06:56:35.241999Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-05-28T06:56:35.242236Z 0 [System] [MY-010910] [Server] D:\DB\mysql-8.0.17-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17) MySQL Community Server - GPL.
05-29
[MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. [MY-013236] [Server] The designated data directory D:\DB\mysql-8.0.17-winx64\data\ is unusable. You can ...
MySQL - 3719 ‘utf8‘ is currently an alias for the character set UTF8MB3
A_bad_horse的专栏
03-26 3445
Warning Description 3719 '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. MySQL Script with warning CREATE TABLE `user` ( `id
Warning: (3719, “‘utf8’ is currently an alias for the character set UTF8MB3, which will be replaced ...
weixin_30613433的博客
05-08 2220
【1】本地版本 Mysql 8.0.12 创建表SQL： DROP TABLE IF EXISTS students; CREATE TABLE `students` ( `sId` INT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `sName` VARCHAR(100) NOT NULL, `sAge` INT(10) NOT NU...
【MYSQL】MYSQL报错解决方法： Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but...
dengbeng4485的博客
12-12 2543
　　 　　用python3.6.5创建mysql库时出现如下报错，虽然报错，但是数据库可以插入成功。 D:\python3\lib\site-packages\pymysql\cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will ...
python utf8mb4_python mysql操作报UTF8MB3警告，最好让你用UTF8MB4的警告
weixin_42508114的博客
12-29 517
python mysql操作报UTF8MB3警告，最好让你用UTF8MB4的警告如下：Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8...
MySQL garbled code
petenover的博客
11-29 620
上一篇咱们唠到spring data redis 自定义注解设置失效时间,文末我把redis可视化贴了出来,几乎没人会发现对象Person的属性name我赋值了"asd"字符串,这是因为我在测试时,用中文本地的mysql出现了中文乱码,所以这次我就回头解决了这个问题,这篇博客与上一篇算是具有一定连贯性. 如果您已经安装了mysql,并且出现中文乱码,首先您要做的是: 1.net stop my...
mysql 8中utf8和utf8mb4运行时的编码告警提醒
fuck487的博客
02-13 7123
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 releas...
mysql: Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/sha
似水流年
10-12 1927
1.场景：由于之前MySQL中一起使用utf8编码，最近由于emoji表情的原因，需要使用utf8mb4编码 操作如下： 修改配置文件/etc/my.cnf： [client] default-character-set=utf8mb4 [mysqld] character-set-client-handshake=FALSE character-set-server
Mysql常见问题总结
蜗牛哲学的博客
06-03 935
这段日志的大致翻译如下。
python用mysql建表的UTF8MB3、UTF8MB4警告
0->1的博客
11-18 7986
今天想练习下myslq的数据库索引，看的教程是https://www.cnblogs.com/chenshishuo/p/5030029.html，结果在创建数据库表的时候就遇到了一个警告。 这是我的python.py # !/usr/bin/env python # -*- coding: utf-8 -*- &amp;amp;quot;&amp;amp;quot;&amp;amp;quot; @Author: P♂boy @License: (C) Copyright ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值