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

最新推荐文章于 2023-11-07 17:19:48 发布
原创 最新推荐文章于 2023-11-07 17:19:48 发布 · 2.1k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql #python #数据库

在使用Python 3.6进行MySQL数据库建表时，遇到关于'utf8'字符集的警告信息，解释了该警告的原因及解决方案。指出MySQL中的'utf8'实际上仅支持UTF8MB3，而非完整的UTF-8标准，建议使用'UTF8MB4'以避免未来数据存储上的潜在问题。
部署运行你感兴趣的模型镜像

用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。

您可能感兴趣的与本文相关的镜像

Stable-Diffusion-3.5

Stable-Diffusion-3.5

图片生成
Stable-Diffusion

Stable Diffusion 3.5 (SD 3.5) 是由 Stability AI 推出的新一代文本到图像生成模型，相比 3.0 版本，它提升了图像质量、运行速度和硬件效率

Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias
漫步量化
04-11 1947
问题描述 在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 4570
| 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
Warning | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias fo...
小呆丶的博客
12-17 4787
MySQL的“utf8”实际上不是真正的UTF-8。“utf8”只支持每个字符最多三个字节，而真正的UTF-8是每个字符最多四个字节。 MySQL一直没有修复这个bug，他们在2010年发布了一个叫作“utf8mb4”的字符集，绕过了这个问题。 简单概况： MySQL的“utf8mb4”是真正的“UTF-8”。 MySQL的“utf8”是一种“专属的编码”，它能够编码的Unicod...
Zhong__ Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an
Zhong的博客
09-18 746
Yishion
(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.
最新发布
08-10
The deprecation warning related to the `utf8` character set indicates that future versions of MySQL will change the default behavior of `utf8` from `utf8mb3` (three-byte characters) to `utf8mb4` (four...
2025-06-11T07:03:58.164034Z 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
06-12
- **警告MY-013242的含义**：这个警告在MySQL 8.0+版本中出现，提示"utf8 is currently an alias for utf8mb3, but will be an alias for utf8mb4 in a future release"。意思是：当前`utf8`是`utf8mb3`的别名，但...
/usr/lib/python3/dist-packages/pymysql/cursors.py:170: 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)
04-20
这个警告是因为MySQL的utf8实际上是utf8mb3，而未来会被utf8mb4取代。所以需要将数据库连接的字符集设置为utf8mb4。用户可能在使用PyMySQL作为驱动，所以需要在SQLAlchemy的连接字符串中指定charset=utf8mb4。同时，...
2025-07-02T07:18:42.061147Z 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-07-02T07:18:42.179313Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory. 2025-07-02T07:18:42.180291Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
07-03
MySQL 提示 `--character-set-server: 'utf8' is currently an alias for the character set UTF8MB3`，这意味着当前使用的 `utf8` 字符集实际上是 `UTF8MB3` 的别名，而未来的版本中它将指向 `UTF8MB4`。...
MySQL - 3719 ‘utf8‘ is currently an alias for the character set UTF8MB3
A_bad_horse的专栏
03-26 3505
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 2241
【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 2580
　　 　　用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 534
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: Character set 'utf8mb4' is not a compiled character set and is not specified in the '/usr/sha
似水流年
10-12 1944
1.场景：由于之前MySQL中一起使用utf8编码，最近由于emoji表情的原因，需要使用utf8mb4编码 操作如下： 修改配置文件/etc/my.cnf： [client] default-character-set=utf8mb4 [mysqld] character-set-client-handshake=FALSE character-set-server
MySQL garbled code
petenover的博客
11-29 651
上一篇咱们唠到spring data redis 自定义注解设置失效时间,文末我把redis可视化贴了出来,几乎没人会发现对象Person的属性name我赋值了"asd"字符串,这是因为我在测试时,用中文本地的mysql出现了中文乱码,所以这次我就回头解决了这个问题,这篇博客与上一篇算是具有一定连贯性. 如果您已经安装了mysql,并且出现中文乱码,首先您要做的是: 1.net stop my...
mysql 8中utf8和utf8mb4运行时的编码告警提醒
fuck487的博客
02-13 7209
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...
python用mysql建表的UTF8MB3、UTF8MB4警告
0->1的博客
11-18 8027
今天想练习下myslq的数据库索引，看的教程是https://www.cnblogs.com/chenshishuo/p/5030029.html，结果在创建数据库表的时候就遇到了一个警告。 这是我的python.py # !/usr/bin/env python # -*- coding: utf-8 -*- """ @Author: P♂boy @License: (C) Copyright ...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值