menu LittleJake's Blog
color_lens
avatar
Jake Liu
Never Settle
creative commons by-nc-sa
hit
Index page
Category
keyboard_arrow_down
未分类 杂七杂八 技术类 DIY
Tag
keyboard_arrow_down
cloudflare centos python thinkphp typecho nginx wifi 华为 MySQL windows 迁移 DNS 维修 安卓 google cdn ipv6 openresty redis 树莓派 玩客云 OpenWrt arduino java ClickHouse Oculus Quest 电池 iPhone 舰娘
Archive
keyboard_arrow_down
November 2024October 2024September 2024August 2024May 2024April 2024March 2024December 2023November 2023October 2023September 2023August 2023July 2023June 2023May 2023April 2023March 2023February 2023January 2023December 2022November 2022October 2022September 2022August 2022July 2022June 2022May 2022April 2022March 2022February 2022January 2022December 2021November 2021October 2021September 2021August 2021July 2021June 2021May 2021March 2021February 2021January 2021December 2020November 2020October 2020September 2020August 2020July 2020June 2020May 2020April 2020March 2020February 2020January 2020September 2019August 2019July 2019June 2019May 2019July 2016June 2016February 2016August 2015May 2015
🔑KMS Key Management System
✅服务状态 Server Monitor
🌐修改语言 Change Language
⚠️免责声明 Duty
🔒隐私 Privacy Policy
📄使用条款 Terms of use

© 2024 LittleJake's Blog.

萌ICP备20223020号

python使用Pymysql操作MySQL报错Incorrect string value

We apologize that the translated content is not provided to this page.

背景

系统：centos 7.6
数据库版本：MySQL8.0

发现问题

Python 使用Pymysql更新数据库时，遇到未知字符。

问题解决

当前列使用类型为longtext；utf8_general_ci
由于传入的字符包括各种符号、各种汉字之类的，utf8明显无法满足业务需求。
因此修改当前列为utf8mb4_general_ci，问题解决

扩展说明

参考MySQL8.0手册可以发现
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb4.html

  1. utf8mb4是4位的utf8编码，而通常utf8为三位，utf8mb4可以理解为utf8的超集。
  2. 支持扩展编码以及BMP

Buy me a beer

buymeacoffee
Jake Liu
Never Settle

Title: python使用Pymysql操作MySQL报错Incorrect string value

Author: Jake Liu

Origin:

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0) For any re-post you must give appropriate credit.

文章遵循CC许可 署名-非商业性使用-相同方式共享 4.0 国际 (CC BY-NC-SA 4.0) 转载请注明出处

Tag:python, MySQL, Incorrect string value, pymysql

评论区

Add a new comment.

生产服务器centos系统watchdog: BUG: soft lockup
CH341A外壳建模Solidwork
Theme