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

In reply to Re^5: insert & retrieve images from DB to web by ksublondie
in thread insert & retrieve images from DB to web by ksublondie

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.