Jump to content

varbinary field truncates to 4096 when retrieving it ?


dieterm

Recommended Posts

Hi,

 

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");

      $STH->execute($data);

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

    $counter = 1;

  $STH->setFetchMode(PDO::FETCH_ASSOC);   

  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

Archived

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.