error in inserting a long blob data

[wes weston]

Diez,
    From your error, you have a DB driver problem. MySql
says to use something like 'they''re' - double up the
inner '


ketulp_baroda at yahoo.com wrote:
> "Diez B. Roggisch" <deets_noospaam at web.de> wrote in message news:<c1ht2m$u7c$01$2 at news.t-online.com>...
> 
>>>values['attachmentpath'] contains the file data.
>>>The data type of the file data is LONGBLOB in MySql.
>>>I am not getting why it works for some file but not for others.
>>
>>Do you have single quotes in your attachment - these would confuse the mysql
>>parser. I don't remember how to quote them for mysql (in oracle its '' for
>>a single quote) - but thats in the manuals.
> 
> 
> How to escape such sequences in python