List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:October 15 2009 7:28pm
Subject:RE: Inserting an Image
View as plain text  
"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 about is storing image data directly in a database is often not a good idea. See these links for more info:

http://mysqldump.azundris.com/archives/36-Serving-Images-From-A-Database.html and http://hashmysql.org/index.php?title=Storing_files_in_the_database

Regards,
Gavin Towey

-----Original Message-----
From: Victor Subervi [mailto:victorsubervi@stripped]
Sent: Thursday, October 15, 2009 12:05 PM
To: mysql@stripped
Subject: Inserting an Image

Hi;
I have successfully inserted images, like yesterday, before into MySQL with
the following code:

      sql = 'update productsX set pic1="%s" where ID=2;' % pic1
      cursor.execute(sql)
where pic1 is simply an image uploaded through a form then sent over without
any alteration to another (python) script that uploads it.  Printing it out
looks like this (other variables included):

update productsX set Name=%s, Title=%s, Description=%s, Price=%s,
Bedrooms=%s, Bathrooms=%s, Conditions=%s, Acreage=%s, Construction=%s,
Location=%s, Estate=%s, Address=%s, Furnished=%s, pic1=%s, pic2=%s, pic3=%s,
pic4=%s, pic5=%s, pic6=%s where ID=%s;', ('name1', 'title1', 'descr1',
'1.1', '2', '1', 'New', '1.5', 'New', 'arbor', 'abor', 'abor', 'Furnished',
'ÿØÿà JFIF ÿÛC "" $(4,$&1' -=-157:::#+?D?8C49:7ÿÛC 7%
%77777777777777777777777777777777777777777777777777ÿÀ y| " ÿÄ ÿÄM !1A Qa "qs
³ 27Bbc‚ #46Rrt‘¡±² $'3C’%5DTUƒ“¢£ÑñÿÄ ÿÄ
ÿÚ ?œ*‹RP’¥¨% d’pªÔcµkä«”øZ Âá îj
Xêxö, `ú@$ý <%60ú@$ý> ô¨2mÒžÚ ¦
ÚRÑ¥¬ò guD|!%bO :ðç’ Z…æµËÚvsM¡·¢&T ‘œ¬ ºâ
“ñ â1Ò¶¶KT[%¦-² {‘£6 Ô÷“âNI=äÒfÓ
ø/RhËîR”³q1 QüÇ“ƒ†pUŽI $à QvÃ
ɼÜ/ZÒì{IrÝ,´£È x ß
#¸$Š· +p}5ùêÿ¹F † vã
Êöy5Ô‚\ˆëO Žc 'ö(Óõku-Ï;
Ö"ÓusN\\Ü‹5{ÑʸvoòÝû@
é ¼×CP U
¤¡%KPJR2I8T+´½¨®{ß{:)kzD‡; &2~1' ¤“
ïÙßA¶Õº®Ç‡Î^8$} ä í=i² Aj ©ôœ
«‰J_u
/¥<ƒ‰%*áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü
dÂsæ–ÝHQB E@ m5Ð QE EbÜî
íP]›q’Üx̧yn8pÿ߇3IP5–¨¿´©úgL2 ¦0 ?ÌU]B
r + ç\»]_"éŸ pTŒŸXU] Èò ­
“¬gK ÑK
,¥Iü29 ƃž6™iU‡]Ý£ È/²G
5~xÇ£8öT۱͡§SÀ ›«¿éˆÈà¥
Æ[ ;ô‡Qן~4»vÒOܬðu ”ëÐÙ Ë
%®a d“Ÿ g ¨Ãe1. õõœÛ æû2
ëËG$4>9' )$xç h3ö‰´Ë®­
ôHî.%œ,†ã ຠx S× ÚV¢‰ >`ÛTíÅß
«.¤¨¥Gžè<€ãŽg½ãP<ìM£h¸1 [ ÌÄ®;J)mA-
ÐR8 :g• ãXjû> ‚™W‡Ô „8) ŽJð} -ÜKp¬’ T–PÔu œî €“Œ
” ôTc¢öó ";= & b*Sê e Æ7xž|p è:@Ö[YÓÚq.1
Ñs¸'€b2 BOÚíkfÐ… õ¤
%ÁÑE<Â|Oœ¯ ŒÌM4Û-!¦
”6€ ”$`$ @ ‚½t¢ƒˆ_Bš}Æ×
ä(¥Yç k®vqyM÷DÚf…º}ZjþÙ¾M/_ ß½E t_Ä™õiþ
°ÖZogV÷ m qŽ¾´:ÛÕÀ÷J«ZÍá i:9ò•(5
ಔŽ' ƒŠ½¥‡ö¡­x ‡ Ž>©UMT3µ- ×ðSýÐ 5†Ñ5
«.³6Yf Õ‘ ºØ‚ ê¬
½Ô±"T‰Kß’û¯+½Å•
ßSVÕö[c´Yn Š~Ùö˦ê‰Ó ¹H6æ
8–ä6¤ öñ Ýð :ž]ƦM
ZJ@ÉRŽ«SfG Ùs^C1ÙI[Ž,à$
¦¢ØÓåm_Pöl¡Ö4m¹à«r ë E¾sIz4†Ën¶z¤ÿ Mr¶Ñt
ý
r)XSö×T|šVï Ï«O𤽉üœ[}cþùtç b
‡ ÓËÐ)7bß'vÿ[#ß.Ä ŸVkΫùTÐÞ® ¹
÷¶¿“k¯¥Ÿ|Šm›Ÿ‚_#ýZ6·÷¹ íÖK4NÖâÓK
H|a¶‰ZˆÂ~qÁë éåKÚ;J^vœJx„þ‘ùî ƒ ý¤Î–[L+
²=¶ØÂYŠÂwP‘ûÉ=I™­ŒÍ!aÓ»IÑŒZ-­0ÓÞZ§BŠœß)g)'xžGˆ©1‹d(÷ 7 c6‰’’„¾ð rÂF Ud[aI
sñ›rTMÿ'uCÎo|aXôŽ [iù5¼qèÏ·ðȦ¹
ꇿWWòÕÉðb\¢9 á WVt F±× ‰ ^Ñâ>¬Ó ¾
Kd6áÛã5 3@„4ÒwRœ’N  ñCƒŸˆ<ˆñ *FûŸ,
ŸªÝ»¸Ùò{sGu];U Ð?˾ eH»vü ¦¯å5]
~@'õ§?‚h$Š(¢€¢Š(
(¢€¢©U (ªUh (¢ƒÿÙ', '', '',
'', '', '', '')

MySQL complains about the image in string form. I'm sure the solution is
simple, but I don't know what it is.
 TIA,
Victor

The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Thread
Inserting an ImageVictor Subervi15 Oct
  • Re: Inserting an Imagejoao15 Oct
  • RE: Inserting an ImageGavin Towey15 Oct
    • Re: Inserting an ImageMichael Dykman15 Oct
      • Re: Inserting an ImageVictor Subervi16 Oct