sqlalchemy_orm报错

pycharm：3.6.3

MySQL：5.7.20

运行提示：Warning: (1366, “Incorrect string value: ‘\xD6\xD0\xB9\xFA\xB1\xEA…’ for column ‘VARIABLE_VALUE’ at row 480”)

但是表正常生成，对于强迫症的有一点错误都不能忍

解决办法：pycharm 安装一个模块

　　　　　　pip install mysql-connector

将engine = create_engine("mysql+pymsql://laoqian:123456@localhost/huanglaoqian_test?charset=utf8")改为：

engine = create_engine("mysql+mysqlconnector://laoqian:123456@localhost/huanglaoqian_test?charset=utf8")

 

转载于:https://www.cnblogs.com/laoqianya/p/11487604.html