Jump to content

varbinary field truncates to 4096 when retrieving it ?


Recommended Posts



I have pdf files strored in a database. When I try to display the pdf file from the database, I can see that the field is truncated.

How do I correct this ?


Here is some code:


      $STH = $DBH->prepare("Select blobFile  from tblDoctors");


  echo $STH->queryString."<p>";

    $counter = 1;


  while($rt = $STH->fetch()) { 


        // Print headers

                header("Content-Type: application/pdf");

              //header("Content-Length: ". $rt['size']);

                header("Content-Disposition: attachment; filename=ampathreports.pdf");


                // Print data



                echo $rt['blobFile'];



I've tried to cast the varbinary file to text but get an error that his type of casting is not allowed


Any help much appreciated....

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.