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: Franck Martin <franck AT sopac.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: MSSQL text field - 4096 limit
  • Date: 10 Jul 2001 08:08:26 +1200


You can increase the limit in the server, or you can use an MS SQL
procedure to slice the field in chuncks of 4096 characters, and put them
in a recordset. At the other end you put them back together.

Cheers.


On 09 Jul 2001 11:09:30 -0500, 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: [Franck AT sopac.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page