I am working with an MSSQL DB which stores images as blob's. When I pull out the blob it seems to be cut off at a fixed length. Every image only displays the top 1/3 or so.
My query is very basic and has no limitations in it for size. Is the information in the DB cut-off? Or do I need to do something inside my query to process a large blob? I'm using ODBC through PHP.
Thank you in advance for ANY help you might be able to offer!
$sqlquery="SELECT image AS theimage FROM IDX_IMAGES_FULL WHERE id='1234'"; $process=odbc_exec($sqlconnect, $sqlquery); $row=odbc_fetch_array($process); $img = odbc_result($process,'theimage'); $img = $row['theimage']; print $img;