store binary files in mysql

Ivan Horvath i.horvath at alco.co.hu
Tue Oct 12 02:51:22 EDT 2004


Dear All,

i would like to store binary file contents to a mysql database in a 
mediumblob fields.
i've got problem when there is a simple quote, double quot, backslash or 
NUL character in the file content, because these characters are 
acceptable by mysql only when there is an escape char. before it.
do you know any solution, how can i replace these characters in order to 
import it to a mysql table?

-- 

Best Regards,

Iván Horváth
Chief Programmer

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/





More information about the Python-list mailing list