Some code would certainly help, as well as your choice of platform. This is a common type of problem, but the causes vary wildly. Trying to diagnose a code problem without source code is like trying to fix a car when it's at home and you're at the garage telling the mechainic about a funny noise you heard coming from the engine.

How you are inserting and retrieving the images is of particular interest. If you could post your INSERT statement, with associated DBI code, it would probably be very clear what your problem is. Also, how are you loading the file? Is it loading completely? You suggest that load_file works, and that is something internal to MySQL, so it could be that you are not reading the entire file.

In reply to Re: MySQL, BLOB, weirdness... by tadman
in thread MySQL, BLOB, weirdness... by cubik

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.