错误提示:
Warning: (1366, “Incorrect string value: ‘\xD6\xD0\xB9\xFA\xB1\xEA…’ for column ‘VARIABLE_VALUE’ at row 1”)
result = self._query(query)
解决方法:
改用mysql-connector-python
第一步:
在命令行下安装模块:mysql-connector-python
pip install mysql-connector-python
或官网下载:
到MySQL官网下载并安装mysql-connector-python:https://dev.mysql.com/downloads/connector/python/
第二步:
将连接引擎的:mysql+pymysql
engine = create_engine(“mysql+pymysql//user:password@host/{data_base}”,encoding=‘utf-8’)
修改为:mysql+mysqlconnector
engine = create_engine(“mysql+mysqlconnector//user:password@host/{data_base}”,encoding=‘utf-8’)
就是将pymysql连接数据库换成了,官方的连接引擎!然后问题解决了!