Skip to Content.
Sympa Menu

freetds - Re: MSSQL text field - 4096 limit

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: 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




Archive powered by MHonArc 2.6.24.

Top of Page