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: TEXT limit of 32768 from ct_fetch/ct_get_data?
Date: Oct 9 2001 4:33PM

Matthew.Persico@Lazard.com writes:
 > One of my collegues is having the following problem. I joined this list to look
 > at the archives. I did not find anything related in the archives, but I might
 > have done a lousy search; I tend to use DBD and don't have any TEXT fields in my
 > apps so I may have just not put the right keywords in. If this is a RTFM, please
 > point me in the direction of the FM and I'll gladly R it. :-)
 > 
 > *********************************************
 > Could you help me to resolve the issue with retrieving data from the TEXT
 > column:
 > 
 > Using CTLib.pm package version 2.11
 > 
 > It appears that I cannot get TEXT column larger than 32,768 bytes.

You need to set the TEXTSIZE option. This can be done via
    set textsize 
or via ct_option().

See the OpenClient manual for ct_option() usage, and the "set" entry
in the ASE Command Reference Manual for the TEXTSIZE option.

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