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üÃâÆÅ¸ ÆE Å Å ( (¢ŠŠ( (¢ŠŠ( Ãê
´{ âmÃYü VTââ pUŽI $à Qvà üÃ/ZÃì{IrÃ,´£à x à #¸$Š·÷F_à ë}â¦â¦Ã¡RTdH ó
Ã#ÃUâö*DÃõ¨Yt]ž îêà +p}5ùêÿ¹F â vã Ãöy5Ãâ\ËëO Žc 'ö(Ãõku-´^4õÃà ã8Ãð%$ ì84
Ã*ø G¥·T Vû#µc æ ·uÃ; Ã"ÃusN\\Ãâ¹5{ÃøvoòÃû@ é ¼ÃCP U
¤¡%KPJR2I8T+´½¨®{Ã{:)kzDâ¡; &2~1' ¤â ïÃÃA¶Ãº®Ãª5 Ãú AiMçá âO â8 â¢tÃpHâNÃ
Uºl¤Ãmë¸é«Ãà øéà ûâ7¼¡@guC q à Šhö cFà Ã\çðäÃâ¡Ã^8$} ä Ã=i² Aj ©ôŠ«â°J_u
/Â¥<Æâ°%*áÃËÃ;˦ TÃö©6)WûjÃZ`ü dÃsæâÃHQB E@ m5à QE EbÃî
ÃP]âºqâÃxçyn8pÿÃâ¡3IP5⨿´©úgL2å©K)aéÃû ¼ 5 ãâs 8žT æÃæ*ýµ)QâÂä4óp⺠¦0 ?ÃU]B
r + ç\»]_"éŸ pTÅŸXU] Ãò  â¬gK ®tTxò^iâ° Ã 4â¡ Rè ¤ à 8 Y«âº` üM ]Êóżâ¬Ã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à â¡Å½3Nû
ÃÃAûêº5ÅâË Â¨qÃà § Ë ÃÃh±ìÃOÃÃV¢Ⱐ>`ÃTÃÂÃ
à «.¤¨¥Gžè<â¬Ã£Å½g½ãP<ìM£h¸1 [ Ãî;J)mAÃ
R8 :g⢠ãXjû> ââ¢Wâ¡Ã ââ Xho8é ÷Gâ¡yÃâ8ñ â¡Â¤Ãµ5ëQÂ¥â°Å¸{žCjxo7"LÃàà ÃG#Ú⡠➨ t
ââº-LjFžhÃËÃXyÂ¥(⦠\8) ŽJð} -ÃKp¬â TâPÃu Åî â¬âÅ â ôTc¢öâ¦Â§ÃZ ëõùµMì hâµ<öwŽ7â¬Ã
1ÃâÅ¡Ã2Â7 ó ";= & b*Sê e Ã7xž|p è:@Ã[YÃÃq.1 Ãs¸'â¬b2 BOÃ_!è > ¡
¦²Ãzòbm©}÷ÆÃªÃ`ÃFâ ¤ $ õ Å â¢vq±èâbÃÃRâ æ\ ËÃÃiÆÃ£Ã¹Ãª °tà Aâ¡Â§4à Ã<ÃoÃÃkfÃ⦠õ¤
%ÃÃE<Ã|Oů ÅÃM4Ã-!¦ â6⬠â$`$ @ â½t¢ÆË_BÅ¡}Ãà ä(Â¥Yç k®vqyM÷DÃfâ¦Ã¯9äéiîþÃ
j³é#>â+â¢Ã¶âlU§]^¢) 'ÃâêüÃ
ùéýà ñ÷?jÃî¯iînÃÅÂøÃ
Gâ^ Ëû@ j@ëA#ëŸâ úïvÅ¡ÃÃGÃ
ëâ |ýò*øÃÃöââ3Ã¥2º}ZjþþM/_ ýE t_Ãâ¢Ãµiþ °ÃZogV÷ m qÃ
½¾´¤ ¼:°2zðï§Ë¿â°Â³ÃªÃü)/bC
7¶ ô Ã.â¬Ã ÿJ:ÃÃÃ÷J«ZÃá i:9òâ¢(5 à ²âŽ' ÆÅ ½¥â¡Ã¶Â¡Âx ⡠Ž>©UMT3µ- ÃðSýà 5â Ã5
«.³6Yf Ãâ ºÃâ ê¬ ½Ã±"Tâ°KÃâû¯+½Ã
⢠ÃSVÃö[c´Yn Å Ããñââ¦Â¡F Úóââ é vqâÃÃVÃ
Ãp!?"D«â· aj kJ ¼ xà óñ çà vC¨eâ Ãëâ¹8J ⢣à :~Ãöæêâ°Ã ¹H6æ 8âä6¤ öñ Ãð :ž]æM
ZÃñ´%®lxqÃâûJ/>â ÃZüõsW3ë³ÃF©Ãé<â¦Ã'ö¢ ÆKi[6â¢â¦Ã¤Ãhik{ £ªóÅt֩\ã è
nV´¡%kPJ@ÃRŽ«SfG Ãs^C1ÃI[Ž,à $ ¦¢ÃÃÃ¥m_Pöl¡Ã4m¹à §w I¸:8⟣Ãîô øâº à t¢â
û¢tÃâËÅ¡â*2 ix â r⦠i)Ãèà î0ò ejmÃà â¦Â¤Ã ¤Ž ÆÃ]«r ë E¾sIz4â Ãn¶z¤ÿ Mr¶Ãt ý
r)XSöÃT|Å¡Vï ôUáûù âlÃÃ:Ãû ]x¡7 ä·1± à , C>ÃGJzà ÃÃoCêÃ<¾µ lâ¡Ã¥
Ãëâ¢Ã¼Å ©ûlc;6½z¶ýê( bþ&ëOð¤½â°Ã¼Å[}cþùtç b â¡ ÃÃÃ)7bÃ'vÿ[#Ã.â¬ÃÃûQü?à Ã
VªóªømOCäsn~?é ®â¢9Þ²çýà ŸVkëùTÃî ¹ ÷¶¿âk¯¥Ÿ|Å mâºÅ¸â_#ýÃXéóiOm_&· ù>ù Ãwâ
â Có$µ à ÃV Jxq4 û 9õ ýRýâézê- V÷®fÃ%%¤ü$žÃ´ñqùÃ)ê pêE$Z6·÷¹ ÃÃK4NÃâÃK
H|a¶â°ZËÃ~qÃë éåKÃ;J^vâ¨dJâú».Ã9:jÃážⰠTqÃr ^[¨öÃ}òV·ÃÃr2ÃÅ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 á â¢1ÅÃû/ )*à d ²¯) R jH(# $pÃu
nÃ3ý ÃsŸîÃçëWVt F±à Ⱐ^Ãâ>¬à ¾ Kd6áÃã5 3@â4ÃwRÅâN ¤ââ-º I dEÅÃOJP[î!8SÅ
¨õáAâE P QE H»QÃë à ^Å[bï $0ò⡠Ãq~ â BOy§ª(8®óg¸Ãç. Ã#±d ñ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
Received on Thu Oct 15 15:05:42 2009
This archive was generated by hypermail 2.1.8
: Thu Oct 15 2009 - 15:17:50 EDT
|