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.
That explains things perfectly!
> -----Original Message-----
> From: Michael Peppler [mailto:email@example.com]
> 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
> Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
> firstname.lastname@example.org - email@example.com
> 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
firstname.lastname@example.org - email@example.com
International Sybase User Group - http://www.isug.com