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 17:22:59 -0700 (PDT)

Brian Bruns writes:
> On Mon, 4 Jun 2001, Michael Peppler wrote:
>
> > Brian Bruns writes:
> > >
> > > >From what I'm seeing, MS is, by default under TDS 7.0, actually
> > sending
> > > the entire text clob all in one go. So technically they are sticking
> > to
> > > the protocol. It just makes the maxlength value useless for
> > preallocating
> > > memory!
> >
> > What?!?!
> >
> > Don't they honour the default TEXTSIZE value?
> >
>
> they do honour it, it's just that they seem to have changed the default to
> 2 gig.

Weird, because it seems that they have the default to a very small
value (I seem to remember 4k) for text *inserts*.

Hmmm... is there a place on microsoft.com where they have
documentation for MS-SQL?

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/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
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/04/2001
- Re: How to read Strings bigger than 255 chars, James K. Lowden, 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, Michael Peppler, 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, James K. Lowden, 06/04/2001
- Re: How to read Strings bigger than 255 chars, Darryl Friesen, 06/05/2001
- Re: How to read Strings bigger than 255 chars, James K. Lowden, 06/05/2001
- Re: How to read Strings bigger than 255 chars, Darryl Friesen, 06/05/2001
- Re: How to read Strings bigger than 255 chars, James K. Lowden, 06/05/2001
- Re: How to read Strings bigger than 255 chars, James Cameron, 06/05/2001
- Re: How to read Strings bigger than 255 chars, Brian Bruns, 06/05/2001