python调用数据库报错_python,mysql_Python pymysql写入数据库报错，python,mysql - phpStudy...

Python pymysql写入数据库报错

我在用Python pymysql写入数据库时一直报错：

pymysql.err.InternalError: (1366, u"Incorrect decimal value: 'xa0' for column 'zuojiesuan' at row 1")

百度的结果是编码问题，我不知道具体怎么解决？

-- coding: utf-8 --

import urllib2

import pymysql

import time

from bs4 import BeautifulSoup

today = time.strftime('%Y-%m-%d',time.localtime(time.time()))

loginHeaders = {

'Host':'www.czce.com.cn',

'User-Agent':'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.106 Safari/537.36',

'Referer':'http://www.czce.com.cn/portal/jysj/mrhq/A091101index_1.htm',

'Content-Type':'text/html',

'Connection':'keep-alive'

}

url='http://www.czce.co