freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: How to read Strings bigger than 255 chars

From: Michael Peppler <mpeppler AT peppler.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: How to read Strings bigger than 255 chars
Date: Mon, 4 Jun 2001 14:56:08 -0700 (PDT)

Darryl Friesen writes:
> >> Eric, if you issue the query "set textsize 10000" prior to selecting
> >> the text column does that also fix the problem?
> >
> > Yes it does! If I just do:
>
> Hmm. Doesn't work for me here. I still get a
>
> Out of memory during "large" request for -2147479552 bytes
>
> in my Perl script (which uses DBD::Sybase)

I seem to recognize this one... I think MS returns the maximum
possible size of the object, instead of the actual size, and I use the
size value to allocate memory for the object in ct_bind() (which of
course fails in your case).

Michael
--
Michael Peppler - Data Migrations Inc. - mpeppler AT peppler.org
http://www.mbay.net/~mpeppler - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com

Re: How to read Strings bigger than 255 chars , (continued)
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/01/2001
- Re: How to read Strings bigger than 255 chars, Paul Schaap, 06/03/2001
- Re: How to read Strings bigger than 255 chars, James K. Lowden, 06/03/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/03/2001
- Re: How to read Strings bigger than 255 chars, Paul Schaap, 06/03/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Eric Deutsch, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Eric Deutsch, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Darryl Friesen, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Michael Peppler, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Darryl Friesen, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Darryl Friesen, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Michael Peppler, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Peter Deacon, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Darryl Friesen, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Michael Peppler, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/04/2001