|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: CS_OPT_TEXTSIZE & ct_get_data()
Date: Jan 23 2002 8:36PM
Shaw, James writes:
>
> In reference to http://taku.cren.net:8080/reguser/archives/SYBPERL-L/log0110/msg00024.html
> (sorry, I just subscribed)
> for the extraction of IMAGE fields more than 32768, I am also
> having the same problem, even after setting TEXTSIZE.
Hmm - I just tried your script, with an image that I just loaded, and
I got:
Col (length) = 4
Data (length) = 106068
Total (length) = 106068
Is it possible that the server has some global limits set?
There is a CS_TEXTLIMIT option that can be set at for the connection
that limits the amount of data that can be retrieved for a TEXT/IMAGE
column. It is possible that this value is set globally in libtcl.cfg
or another of the .cfg files in $SYBASE/config or
$SYBASE/$SYBASE_OCS/config.
Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
|
