python爬取数据然后存入mysql,python直接输出是中文,在mysql的表中打开变成乱码了?
#这是python的代码:
cont=urllib2.urlopen(url).read()
rex=re.compile(r'\"tmall_vip_level\":(.*?)\,\"spuId\".*?\"sku\":(.*?)\,\"enableTime\".*?\"displayUserNick\":(.*?)\,\"displayUserNumId\".*?\"rateContent\":(.*?)\,\"rateDate\":(.*?)\,\"reply\"',re.S)
contents=rex.findall(cont)
for content in contents:
conn = MySQLdb.connect(host='127.0.0.1', user='root',passwd='19940513cc', db='pythonJD',port = 3306, charset = 'utf8')
cur = conn.cursor()
sql='INSERT INTO proxy(level,sku,user,content,date)values(%s,%s,%s,%s,%s)'
cur.execute(sql, (content[0],content[1].decode('gbk').encode('utf-8'),content[2].decode('gbk').encode('utf-8'),content[3].decode('gbk').encode('utf-8'),content[4]))
print 'success connect'
conn.commit()
cur.close()
conn.close()
mysql和python中所有的都设置为utf8了。是要修改数据库配置文件嘛,在哪改呢....