Cool! now regarding the incomplete images I found a snippet earlier on DBI and blobs that may explain your problem if all the images are trunacted to a certain size. I don't have much experience with BLOBS, though.
I found it in the DBI::FAQ doc under '5.2 How do I handle BLOB data with DBI?'
As for the first advice to convert to JPEG unconditionally and that GIF89a is only the animated GIF format I would disagree. JPEG was designed for photgraphic images, GIF can get smaller sizes when less colors are necessary. Pretty much every GIF around now is GIF89a, the format that supercedes GIF87a, even if they are not animated.
As for image file format advice I would convert to PNG. PNG was created to replace the GIF format, has smaller file sizes, increased color depths, transparent alpha blending, and I _think_ a specific grayscale color model. The only downside is older browsers (IE especially) have poor or no support for it. Oh and it isnt animated but that wont affect you.
| [reply] |
some of the images are incompleteJust from my previous dealings with animated gifs, you may be seeing the effects of the interlacing and compression. The later gifs, can be optimized for size, and it usually is done by only storing the "changed image pixels" in subsequent images( or something like that concept). What you will need to do is run the animted gif thru a competant extraction utility, that will rebuild each image fully. Try Gifsicle .
| [reply] |
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 | [reply] |