PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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