Skip to Content.
Sympa Menu

freetds - Re: Text field problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT speakeasy.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Text field problem
  • Date: Mon, 10 Sep 2001 23:49:45 -0400


Bob Kline wrote:
>
> On Mon, 10 Sep 2001, Greg Chakmakian wrote:
>
> > I did some searching through the archives and found some info, but
> > no specifics on this problem I'm having. What happens is that
> > whenever I try to get data out of a text field in a database then I
> > only get back around 4 KB. I am using IIS 5 with Tomcat and am
> > hitting a sql server 7 database. It brings back the same amount
> > every time: ~4096 bytes. Has anyone else had problems along these
> > lines? Any help would be greatly appreciated.
>
> Please look again. This question comes up regularly. Try, for example,
> searching on "SET TEXTSIZE".
>
> Any chance this could be added to the FAQ document?

Harrumph! Well, yes, ok, maybe, sure.

I did try to address it in the User Guide, under "Text Fields". And
MS's documentation states that 4096 is the default TEXTSIZE value.

http://www.freetds.org/userguide/x556.htm#AEN558

But maybe you're right, Bob. Maybe in the FAQ under "Problems Running"
there should be a subsection (called "RTFM"?) explaining a few things
like this that people bump into from time to time. It is one of the
goofier parts of T-SQL.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page