store binary files in mysql
i.horvath at alco.co.hu
Tue Oct 12 09:27:38 CEST 2004
thank you very much it is working fine.
Dragos Chirila wrote:
> Use escape_string method from MySQLdb module.
> Ivan Horvath wrote:
>> 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?
More information about the Python-list