Skip to Content.
Sympa Menu

freetds - Re: How to read Strings bigger than 255 chars

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page