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.

In reply to Re^5: insert & retrieve images from DB to web by juster
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.