0x00 错误情况
- MySQL版本:mysql Ver 8.0.13 for Win64 on x86_64 (MySQL Community Server - GPL)
- 报错情况如下
E:\Python\Python36\lib\site-packages\pymysql\cursors.py:170: Warning: (1366, "Incorrect string value: '\\xD6\\xD0\\xB9\\xFA\\xB1\\xEA...' for column 'VARIABLE_VALUE' at row 519")
0x01 解决方法
- 拒绝使用
pymsql
,转而使用mysql-connector-python
(听说mysql-connector
也可以) - 安装
pip install mysql-connector-python
- 修改引擎:
app.config['SQLALCHEMY_DATABASE_URI'