sybperl-l Archive

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 mpeppler@itf.ch
> 
> 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...)
$F->dbsqlexec; $F->dbresults;

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.

Michael