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:59PM

Shaw, James writes:
 > 
 > Sincere apologies to all.
 > 
 > I have just found out that my colleague copied these images from another dataserver using bcp but without specifying the
 > -T option, so only the first 32K of each image were copied. I'm also annoyed with myself for not checking this earlier.
 > 

Ah.

:-)

That explains things perfectly!

Michael


 > -----Original Message-----
 > From: Michael Peppler [mailto:mpeppler@peppler.org]
 > Sent: 23 January 2002 15:36
 > To: SybPerl Discussion List
 > Subject: Re: CS_OPT_TEXTSIZE & ct_get_data()
 > 
 > 
 > 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
 > 
 > Visit our website at http://www.ubswarburg.com
 > 
 > This message contains confidential information and is intended only 
 > for the individual named.  If you are not the named addressee you 
 > should not disseminate, distribute or copy this e-mail.  Please 
 > notify the sender immediately by e-mail if you have received this 
 > e-mail by mistake and delete this e-mail from your system.
 > 
 > E-mail transmission cannot be guaranteed to be secure or error-free 
 > as information could be intercepted, corrupted, lost, destroyed, 
 > arrive late or incomplete, or contain viruses.  The sender therefore 
 > does not accept liability for any errors or omissions in the contents 
 > of this message which arise as a result of e-mail transmission.  If 
 > verification is required please request a hard-copy version.  This 
 > message is provided for informational purposes and should not be 
 > construed as a solicitation or offer to buy or sell any securities or 
 > related financial instruments.
 > 

-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com