redis - When running a python crawler, the MySQL version is 5.7 and an error is always reported

Question

When running the python crawler, the MySQL version is 5.7 and an error is always reported

C:\Python34\lib\site-packages\pymysql\cursors.py:166:
Warning: (1366, "Incorrect string value: '\xD6\xD0\xB9\xFA\xB1\xEA...' 
for column 'VARIABLE_VALUE' at row 480")
result = self._query(query)

What's the problem? How to solve it?

Answer 1

What encoding do you use mysql for?

Answer 2

The warning is that there is an incorrect character value in line 480. The encoding of the file is inconsistent with the encoding setting of MySQL