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





Archive powered by MHonArc 2.6.24.

Top of Page