Re: Inserting an Image

2009-10-16 Thread Victor Subervi
Well, I've spent the last 2 days chasing my tail just to discover that there was some screwy python deal going on. The following code works: sql = "update productsX set Name='%s', Title='%s', Description='%s', Price='%s', Bedrooms='%s', Bathrooms='%s', Conditions='%s', Acreage='%s', Construc

Re: Inserting an Image

2009-10-15 Thread Michael Dykman
Victor, again, your question has more to do with python usage than MySQL per-se.. you would be better off pursuing these questions in a python forum. - michael dykman On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey wrote: > "Image in string form"  sounds like you're not inserting binary data, r

RE: Inserting an Image

2009-10-15 Thread Gavin Towey
"Image in string form" sounds like you're not inserting binary data, rather some sort of encoded data. Even if it is binary, you'll have to escape at least end quote characters, you can see clearly at the top of your data there is : 'ÿØÿà JFIF ÿÛC "" $(4,$&1' Another thing to think abo

Re: Inserting an Image

2009-10-15 Thread Jo�o C�ndido de Souza Neto
The first thing I think I have to sey is "it´s not a good idea to save image data in a mysql table field", the best way is to save the file in your file system and the file name in the table field, but, if you like to do that, it´s better to be a blob field. "Victor Subervi" escreveu na mens