mod_python and storing binary form data

canistel at canistel at
Thu Apr 10 20:43:23 CEST 2008

Hi, I have a little python webservice that I created, and in one of
the methods I need to store some binary data that was "posted"... I
want to do something like this, but it doesn't work.

username = form.get("username", "")
message = form.get("message", "")
attachment = form.get("attachment", None)
c.execute("""INSERT INTO Message (username, message, attachment)
VALUES (%s, %s, %s)""", (username, message, attachment))

"attachment" is then some binary data that was posted, but when I look
in the mysql database, I see values for the attachment field which
look like:

Field('attachment', '\x89PNG\r\n\x1a\n\x00\x00\...

so it is storing something, just not my binary data (in this case a
picture). the attachment column is a longblob in mysql.

More information about the Python-list mailing list