post时数据库出现错误

[yingluck]

向网站提交数据时网站数据库出错,大概能看出是提交内容格式不正确,但是怎么改却没有头绪,求众V2EXer帮忙
INSERT INTO et_content (user_id,content_body,posttime,type) VALUES ('24579','<Storage {'title': u'fg'}>','1384345479','weixin') Error: 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 'title': u'fg'}>','1384345479','weixin')' at line 1

[qiayue]

('24579','<Storage {'title': u'fg'}>','1384345479','weixin')
改为
('24579','<Storage {"title": "ufg"}>','1384345479','weixin')
或者
('24579','<Storage {\'title\': \'ufg''}>','1384345479','weixin')

你原文的 u'fg' 我认为是你手误，你本来想写的是 'ufg' 吧？

[qiayue]

我也手误了
或者
('24579','<Storage {\'title\': \'ufg\'}>','1384345479','weixin')

[shiny]

怎么 content 存的这个，先把 python Storage 对象正确转成字符串+转义吧。

[yingluck]

@qiayue 多谢指正!

[yingluck]

@shiny 能详细讲一下吗?python 新手求问!