scrapy爬虫存mysql时报错

[木木XD]

语句代码：
quiry = "INSERT INTO baike(url, mingcheng, jianjie, jibenxinxi, mulu, neirong, citiaotongji, cankaoziliao, biaoqian)\
VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s')"\
%(item['url'], item['mingcheng'], item['jianjie'], item['jibenxinxi'], item['mulu'], item['neirong'], item['citiaotongji'], item['cankaoziliao'], item['biaoqian'])
cursor.execute(quiry)

报错：
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\\u91d1\\u671d\\uff08\\u4e2d\\u56fd\\u5386\\u53f2\\u671d\\u4ee3\\uff
09_\\u767e\\u5ea6\\u767e\\' at line 1


如果语句只插入一个url就可以，但是只插入其他的就不行，看这个应该是中文编码的问题？
数据库是utf8编码的，爬的中文显示的是Unicode，希望能将中文存入数据库，请问怎么解决，谢谢。。

[*xhades]

中文是不是要encode成utf-8？

[random7]

所以你要Unicode转成utf-8，用str.encode('utf-8')

[oyljerry]

把拿到的unicode数据编码成utf8