freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: MSSQL text field - 4096 limit

From: Michael Peppler <mpeppler AT peppler.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: MSSQL text field - 4096 limit
Date: Mon, 9 Jul 2001 09:14:20 -0700

Lance writes:
>
> 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?

The limit is set by the server, not the client (by default).

It can be upped with a "SET TEXTSIZE xxx" command.

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

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