mysql8 字符集

【MYSQL】MYSQL报错解决方法： Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but...

dengbeng4485 2018-12-12 17:27:00  487  收藏

文章标签： 数据库 python 开发工具

版权

　　

　　用python3.6.5创建mysql库时出现如下报错，虽然报错，但是数据库可以插入成功。

1.  
   D:\python3\lib\site-packages\pymysql\cursors.py:170: Warning: (3719, "'utf8' is
2.  
   currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4
3.  
   in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
4.  
   result = self._query(query)
5.  
    

　　

　解决方法

• 　　python版本：3.6.5
• 　　mysql版本： 8.0.12

　　

　　1. 首先查看下mysql字符集

1.  
   mysql> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
2.  
   +--------------------------+--------------------+
3.  
   | Variable_name | Value |
4.  
   +--------------------------+--------------------+
5.  
   | character_set_client | gbk |
6.  
   | character_set_connection | gbk |
7.  
   | character_set_database | utf8mb4 |
8.  
   | character_set_filesystem | binary |
9.  
   | character_set_results | gbk |
10.  
    | character_set_server | utf8mb4 |
11.  
    | character_set_system | utf8 |
12.  
    | collation_connection | gbk_chinese_ci |
13.  
    | collation_database | utf8mb4_0900_ai_ci |
14.  
    | collation_server | utf8mb4_0900_ai_ci |
15.  
    +--------------------------+--------------------+
16.  
    10 rows in set, 1 warning (0.04 sec)

　　

　　2. 根据上述查询结果，修改sql语句

1.  
   修改前 = 'CREATE DATABASE IF NOT EXISTS database_name DEFAULT CHARSET utf8 COLLATE utf8_general_ci;'
2.  
   修改后 = 'CREATE DATABASE IF NOT EXISTS database_name DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci;'

　　DEFAULT CHARSET utf8 COLLATE utf8_general_ci 是之前老版sql的写法。

　　

　　代码执行创建成功~(๑•̀ㅂ•́)و✧

　 

　　相关知识补充

　　UTF8MB4与UTF8MB3的区别介绍：https://dev.mysql.com/doc/refman/5.6/en/charset-unicode-utf8mb4.html