FreeTDS Development Group

["Spectron Caribe, Inc." <spectron AT caribe.net>]

That's not a solution. The source should be fixed instead of going around
it. Go and check the source code, in Connection_base.java there is a
function called sqlStatementInitialize() that looks like this (this is from
memory, so it might be wrong):

protected String sqlStatementToInitialize(){
   if(serverType==Tds.SYBASE){
        return("set quoted_identifier on set textsize 50000");
   }else{
     return("");
   }
}

Just change it to:

protected String sqlStatementToInitialize(){
   return("set quoted_identifier on set textsize 50000");
}

If you want something better let the user set the text size in a parameter
in the connection url (that's what I did) if there is no parameter, use the
50000 ad default.

Faw

----- Original Message -----
From: "Bob Kline" <bkline AT rksystems.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Monday, September 10, 2001 3:28 PM
Subject: [freetds] Re: Text field problem


> 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?
>
> --
> Bob Kline
> mailto:bkline AT rksystems.com
> http://www.rksystems.com
>
>
> ---
> You are currently subscribed to freetds as: [spectron AT caribe.net]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>