in reply to Re^4: insert & retrieve images from DB to web
in thread insert & retrieve images from DB to web

Just tried the png which would be perfect...however, content type image/png doesn't work and I'm getting the dreaded red 'x' (both IE7 & FF browsers). The raw data LOOKS ok though...

I'm confused by the animated gif discussion: I'm starting out w/static 2 color tif's (all <14K), running a straight-forward conversion w/ImageMagic to a gif using the defaults, nothing is animated. The 'original' gifs look fine. Somewhere between inserting to db, retrieving from db, and converting data from hex, I'm only getting partial display and/or snow on some images.

The images that are jacked up are generally, but not all, the larger files. Of the subset that I looked at, most of my bad/partial images are around 30K, but one of them is only 15K, a 27K isn't showing, but a 29K is. The most of my <30K images are showing up. I can try playing with the blob, but when comparing the rawdata size of one of the original gif vs. the jacked output gif, they're the EXACT same length (at most 1B off). So, it doesn't look like I'm truncating data somewhere in the conversion.

Here's a thought: since inserting raw data mysteriously converts to hex, can I cast or convert in my select to convert back to the raw data? While I eagerly await your response, I'll see if google knows.

--ksublondie
  • Comment on Re^5: insert & retrieve images from DB to web