Edit history

Edit: -1 of 2
Time: 2007-09-07 17:03:55
Note: /dabosite/wiki/HowToAddBLOBValuesWithMySQL/edit "Removed need for escape_string()"

changed:
-crs.execute("""INSERT INTO blobtable SET b="%s" """ % escape_string(binarydata))
#crs.execute("""INSERT INTO blobtable SET b="%s" """ % escape_string(binarydata))

# PKM: actually, I've found that this step isn't necessary. Just 
# remove the quotes, e.g.:
crs.execute("INSERT INTO blobtable SET b=%s" % binarydata)