Ver Mensaje Individual
  #1  
Antiguo 31-01-2011
mavirroco mavirroco is offline
Registrado
NULL
 
Registrado: ene 2011
Posts: 1
Reputación: 0
mavirroco Va por buen camino
migrar blob de firebird a blob mysql

hola quiero migrar mediante inserts mis datos de firebird a mysql..todo bien excepto los campos blob..por ej..
INSERT INTO PRODUCTO(codigo,nombre,descripcion,precio,foto)VALUES('27-AA-1025K','AMOLADORA ANGULAR 125MM','AMOLADORA ANGULAR DE 41/2" NEO','1041.0000','BM¦6((pÄÄıııöööĞÑĞ™˜—igfPONFEC@?>755000ZVM‘†n›|û¯íëèıııïïïõõõıışııııııııı ııııııııııııııııııııııııııııııııııııııııııııııııııııııôôô§¦¦][ZB?>64231431:/.3&&$#$d]J—‰mœr£’w¶¥ĞÎÊnnm‹Œ‹áââıııııııııııııııııııııııııııııııııııııııııııııııııııııııııııııııµµµRPQ@==653 44E@>v62€0/K&&#HE9{sVƒx[’„f©–v²œxqe–——÷÷÷ıııııııııııııııııııııııııııııııııııııııııııııııııııııııııııı_^_B@C87900@TS¢V TŒ52S,,/**%nfR|rWpgO{pT€`wkVaZK/-(#$!–––÷÷÷ııııııııııııııııııııııııııııııııııııııııııııııııııııııııııııdceA?B4450.SYW«b[kƒva‡{es]„x^jbLXRANI:^WGd\N`XLVPFš—”ïïïııııııııııııııııııııııııııııııııııııııııııııııııııııııııııııııı¹¸¹OMO: 8:0/;ZRˆ±‘µ£‡™Œv•ˆp‰~hSO@##`YKh_PKD:…êêêşşşıııııııııııııııııııııııııııııııııııııııııııııııııııııı ıııııııııôôô¦¦§QPRA>>¡}Ô½¢Á¯˜™Šz’†v‚yi76,84,g_OSL?GC uîíêıışşşşşşşşşşıııııııııııııııııııııııııııııııııııııııııııııııııııııııııûûüØÙÛ³¬¥Ê´×«ÕÁ*°œ¡“w g97/74+;8.42)54if†(¤ŸXÁ¾ßÜÆïîäööğûûúşşÿıııııııııııııııııııııııııııııııııııııııııııııııışşşÿÿÿñíéË ¸£Ò¿ªÚɵİÌ·Ôª»«’~td#$=8.,*#..caead]ng‚|—<¯«hÈÅ•âàÁëêßõõõıışşşşııııııııııııııııııııııııııııııııııııııışşşôòïIJ˸¡ÕÁ«ÛȳÛ˵ÜʳÖê–‹z GC<<72D?:eb2hdc^LG-ID7d^?jd3pj~xƒ}&”M–“†²±±ôôôşşşıııııııııııııııııııııııııııııııııııııııüüıİÕÏÄ°Ç°šÑ»£ÚȱßÏ»ÓïɷŸÆ ´œ¬Š´£–˜Puoyzs ohg_)c\=\W;73/Ÿüüüııııııııııııııııııııııııııııııııııııııııııııüêçãƺ®‰tt¸ª˜š’…® ª™ˆ¦™Êº¨¦™A‘…Ÿ™‘††}€wD@BA:8)% _\WççåşşşıııııııııııııııııııııııııııııııııııııııııışşşôóñÂÀ¾Š…~œ“‡¬¢–¾¯Í½«Ê¿³ÖÊ®¸¥,®›¨—§•§–¨—§— §–£” UN!94+VPGÄÃÂşşşşşşşşşşııııııııııışşşıııııııııııııııııııııııışşşıııéçåý¶À´£º¬›ÙÈ´Û˶Ƿgº¤ »¤¸¡¸ ¶ µŸ³³°œ°œš‰ \S-KD5[UG‡˜¾ËåÏÙîòõûÿÿÿşşşşşşıııîíîîïïüüüıııııııııııııııııııııııııııóòğÒË÷ªœÅ²š¾©c´Ÿ¶ ¹¢º£½¤¿¥Á¥Â¦Á¦¿¥»£”ƒ^V;WO=cZFa_WGN]JRhhm}„†œ ²³²²±°ffd¡¢¡öööıııııııııııııııııııııııııııışşúûûìèåßÖÇÙÓ¢ÚÓ˜ÙÑ’ÏÃmǸNð7¿ª%¼¦¾¥À¦¿¥*—q6jaHjaGka HbZCF?0@:-@:/?:1B=4C>5D@6C=4zun¸¶²ııııııııııııııııııııııııııııııııııışüüışşşşşşşşşùúøõôèïìÕéã¾Ş×£ÖÌĞÂb¹«9ˆ:aZIa ZGg_Ii_Hi`Fh_Ee]Fe]Gf]Hg]Hf\Hf\Gh]Hyq`‘‹‚üüüıııııııııııııııııııııııııııııııııııııııııııııııııııııııışüüıûúöø÷íñïŞãâÚÍÍÌÂÁÁÂÂÀ°®ª™—…t tn^b\K`XGaZGdZG`WEg_Q¼º³íìê');

esto inserta bien en mysql pero el campo blob no reconoce y no me muestra imagenes en el gestor de imagenes..

supongo que se tiene que hacer alguna conversion antes ...


alguna idea?


Manuel Rodriguez Coria
mavirroco@gmail.com
Responder Con Cita