freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: MSSQL text field - 4096 limit

From: Brian Bruns <camber AT ais.org>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: MSSQL text field - 4096 limit
Date: Mon, 9 Jul 2001 15:57:00 -0400 (EDT)

That is a Microsoft imposed limit. Simply issue the query "set textsize
8192" after opening a connection to adjust it.

Brian

On Mon, 9 Jul 2001, Lance wrote:

>
> I have just recently found that a text field will
> only return a maximum of 4096 characters.
>
> What is the thinking behind this limit? Are there
> any problems with bumping that up to say 8192?
>
> lance
>
> ___________________________________________________________________
> To get your own FREE ZDNet Onebox - FREE voicemail, email, and fax,
> all in one place - sign up today at http://www.zdnetonebox.com
>
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>

MSSQL text field - 4096 limit, Lance, 07/09/2001
- <Possible follow-up(s)>
- Re: MSSQL text field - 4096 limit, Michael Peppler, 07/09/2001
- Re: MSSQL text field - 4096 limit, Spectron Caribe, Inc., 07/09/2001
- Re: MSSQL text field - 4096 limit, Brian Bruns, 07/09/2001
- Re: MSSQL text field - 4096 limit, Franck Martin, 07/09/2001
- Re: MSSQL text field - 4096 limit, Kevin Fries, 07/10/2001