我试图解析一个俄罗斯网站(西里尔文),并将数据插入mySQL数据库。解析很好,但由于西里尔字母的原因,我无法将数据保存在数据库中。Python给我这个错误:
Traceback (most recent call last):
File "/Users/kr/PycharmProjects/education_py/vape_map.py", line 40, in <module>
print parse_shop_meta()
File "/Users/kr/PycharmProjects/education_py/vape_map.py", line 35, in parse_shop_meta
VALUES (%s, %s, %s, %s)""",(shop_title, shop_address, shop_phone, shop_site, shop_desc))
File "/Library/Python/2.7/site-packages/MySQLdb/cursors.py", line 210, in execute
query = query % args
TypeError: not all arguments converted during string formatting
我的代码:
^{pr2}$
%D0%9C%D0%BE%D1%81%D0%BA%D0%B2%D0%B0
是Москва
的编码,因此看起来没问题。但您还需要确定utf8将用于与MySQL的连接。并指定目标列是CHARACTER SET utf8
。在More details和Python-specifics
相关问题 更多 >
编程相关推荐