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" <victorsube...@gmail.com> escreveu na mensagem 
news:4dc0cfea0910151204m783904b3uaae1467931a30...@mail.gmail.com...
> 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'%5DTUf"¢£ÑñÿÄ ÿÄ ÿÚ ?o*<RP'¥¨% d'pªÔcµkä«"øZ Âá 
> îj
> Xêxö, `...@$ý <%6...@$ý> ô¨2mÒzÚ ¦ ÚRÑ¥¬ò guD|!%bO :ðç' Z.æµËÚvsM¡·¢&T 'o¬ ºâ
> "ñ â1Ò¶¶KT[%¦-² {'£6 Ô÷"âNI=äÒfÓ ø/RhËîR"³q1 QüÇ"fY fE S S( (¢S S( (¢S 
> S( ×ê
> ´{ -mÒYü VTâ?pUZI $à Qvà ɼÜ/ZÒì{IrÝ,´£È x ß #¸$S·÷F_Ë ë}..áRTdH ó
> Á#ÐU"ö*DÙõ¨Yt]z îêÑ +p}5ùêÿ¹F ? vã Êöy5Ô,\^ëO Zc 'ö(Óõ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 Ó ShÙ¶ cFØ Í\çðäÇ?Î^8$} ä í=i² Aj ©ôo «?J_u
> /¥<f?%*áÓ^Î;^¦ TÐö©6)WûjØZ`ü dÂsæ-ÝHQB E@ m5Ð QE EbÜî
> íP]>q'Üx̧yn8pÿß?3IP5-¨¿´©úgL2å©K)aéÒû ¼ 5 ã,s 8zT æÕæ*ýµ)Q'­ä4óp> ¦0 
> ?ÌU]B
> r + ç\»]_"éY pTOYXU] Èò ­ "¬gK ®tTxò^i? É 4? Rè ¤ à8 Y«>` üM ]ßSóO¼?ÑK
> ,¥Iü29 Æfz6TiU?]Ý£ È/²G 5~xÇ£8öT۱͡§SÀ >«¿é^ÈॠÆ[ ;ô?Q×Y~4»vÒOܬðu "ëÐÙ 
> Ë
> %®a d"Y g ¨Ãe1. õõoÛ æû2 ëËG$4>9' )$xç h3ö?´Ë®­ ôHî.%o,?ã ຠx S× ?Z3Nû
> ÐËAûêº5O,^ ¨qÁà§ ^ ÓÜh±ìËOÏÚV¢? >`ÛTíÅß «.¤¨¥Gzè<?ãZg½ãP<ìM£h¸1 [ 
> ÌÄ®;J)mA-
> ÐR8 :g. ãXjû> ,TW?Ô "?Xho8é ÷G?yÀâ8ñ ?¤õ5ëQ¥?Y{zCjxo7"LÑÚ­ à ØG#Ãs? 'z¨ t
> ->-LjFzhÃ^ÂXy¥(. \8) ZJð} -ÜKp¬' T-PÔu oî ?"O " ôTc¢ö.§íZ Ò«õùµMì 
> h,µ<öwZ7?É
> 1Î'sÛ2­7 ó ";= & b*Sê e Æ7xz|p è:@Ö[YÓÚq.1 Ñs¸'?b2 BOÓ_!è > ¡
> ¦²Özòbm©}÷fêÂ`ÂFâ ¤ $ õ S.vq±è-bÍÏR?æ\ ^ÃÎifãùê °tÏ A?§4Þ Ú<ÆoÚíkfÐ. õ¤
> %ÁÑE<Â|Oo¯ OÌM4Û-!¦ "6? "$`$ @ ,½t¢f^_Bs}Æ× ä(¥Yç k®vqyM÷DÚf.ï9äéiîþÑ
> j³é#>,+Tö'lU§]^¢) 'Ê"êüÅùéýÊ ñ÷?jÔÛ®¯iÙ®nÇo­øÅG,^ ^û@ j...@ëa#ëy" ú̯vsÈÛGÉ
> ë?|Ö½ò*θÇßö"â3å2º}ZjþÙ¾M/_ ß½E t_ÄTõiþ °ÖZogV÷ m q޾´¤ 
> ¼:°2zðï§~¿?³êÓü)/bC
> 7¶ Ë´ ß.?Ò ÿJ:ÛÕÀ÷J«ZÍá i:9ò.(5 à²"Z' fS½¥?ö¡­x ? Z>©UMT3µ- ×ðSýÐ 5?Ñ5
> «.³6Yf Õ' ºØ, ê¬ ½Ô±"T?Kß'û¯+½Å. ßSVÕö[c´Yn SÔãñ".¡F Âsó-" Þ© vq"ÝÀVÝ
> Óp!?"D«"· aj kJ ¼ xà óñ çÆ vC¨e?Öë<8J '¢£à :~Ùö˦ê?Ó ¹H6æ 8-ä6¤ öñ Ýð 
> :z]ƦM
> Zíñ´%®lxqÛ"ûJ/>?ÀZüõsW3Ê«³ÒF©Öé<.Ñ'ö¢ fKi[6..äÖhik{ £ªóot÷©\Ï£ è
> nv´¡%...@Érz«sfg Ùs^C1ÙI[Z,à$ ¦¢ØÓåm_Pöl¡Ö4m¹à§w I¸:8"Y£Èîô ø'º Í t¢,
> û¢tÂ-~s-*2 ix ?r. i)ÏèÔ Ë®0ò ejmÆÔ .¤à¤Z fß]«r ë E¾sIz4?Ën¶z¤ÿ Mr¶Ñt ý
> r)XSö×T|sVï ôUÜ¡ûù 'lÚÑ:Æû ]x¡7 Ò¤·1± Ù , C>ÐGJzÛ ÎÍoCêÛ<¾µ l?å
> Çë.üS©ûlc;6½z¶ýê( bþ&Ï«Oð¤½?üo[}cþùtç b ? ÓËÐ)7bß'vÿ[#ß.?ÒÃûQÖ¼? Ç
> VªóªømOCäsn~?é ®T9Úz²çýÄ YVkΫùTÐÞ® ¹ ÷¶¿"k¯¥Y|Sm>Y,_#ýÝXéóiOm_&· ù>ù Ëw-
> ?Có$µ Á ÇV Jxq4 û 9Ùµ ýRýâézϪ- V÷®fÞ%%¤ü$zÍ´ñqÓ¹É)ê pêE$Z6·÷¹ íÖK4NÖâÓK
> H|a¶?Z^Â~qÁë éåKÚ;J^v"¨dJ'ú».Ð9:jÀáz? TqÀr ^[¨öÏ}òV·íÚr2ÂoJx"þ'ùî f 
> ý¤Î-[L+
> ²=¶ØÂYSÂwP'ûÉ=IT­OÍ!aÓ»IÑOZ-­0ÓÞZ§BSoß)g)'xzG^©1<d(÷ 7 c6?''"¾ð rÂF Ud[aI
> sñ>rTMÿ'uCÎo|aXôZ [iù5¼qèÏ·ðȦ¹ ê?¿WWòÕÉðb\¢9 á T1oÆû/ )*Á d ²¯) R jH(# 
> $pÇu
> nÇ3ý ÙsYîÜçëWVt F±× ? ^Ñâ>¬Ó ¾ Kd6áÛã5 3@"4ÒwRo'N ¤"í¢-º I dEOÓOJP[î!8SS
> ¨õáA"E P QE H»QÙë Ò ^O[bï $0ò? Ïq~ â BOy§ª(8®óg¸Øç. Ú#±d ñCfY^<^ñ *FûY,
> YªÝ»¸Ùò{sGu];U Ð?˾ eH»vü ¦¯å5] ~@'õ§?,h$S(¢?¢S( (¢?¢©U (ªUh (¢fÿÙ', '', 
> '',
> '', '', '', '')
>
> 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
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to