Up Prev Next
From: mpeppler at itf dot ch (Michael Peppler)
Subject: Re: Can Not Retrieve Image Greater Than 4k
Date: Feb 13 1996 6:40AM
> From: Richard Ruth
0 PL44] for email@example.com
> I have a table that has an id column (int) and an image (image). When I use the following perl script
> to retrieve the image and place it in a file, I only receive the first 4096 bytes (assuming that the
> image is longer than 4k).
> Any suggestions on how to retrieve the Entire image would be appreciated.
> I am using Perl 5.001m and Sybperl 2.0 compiled with sybase lib 4.6.
With sybperl 2.0, you need to do something like:
$F->dbcmd("set textsize 64000"); # (or whatever...)
As of 2.03, you can do:
$F->dbsetopt(DBTEXTSIZE, "64000"); # or whatever size you wish...
See also the DBTEXTLIMIT option in the DBlib manual.