FreeTDS Development Group

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

> ----- Original Message -----
> From: "Brian Bruns" <camber AT ais.org>
> To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
> Sent: Friday, May 04, 2001 8:53 PM
> Subject: [freetds] Re: LONGVARCHAR in freetds JDBC max size is 4096?
>
>
> > If I remember correctly SQL Server sets the default text size to
> > 4096...Issue the command:
> >
> > set textsize 65356
> >
> > before your query (where 65356 is some number large enough the
accomadate
> > your data).
> >
> > Brian
>
> Ok, I'm going to try that. The thing is that in ODBC and ADO I don't have
> to. That's why I thought is was a driver problem. Anyway I'm going to try
> another driver I have here and see if it works without the 'set textsize'
> command.
>
> Faw

Well, It must be the driver. I downloaded a trial driver from
http://www.inetsoftware.de (I tested Sprinta) and it works. The datalength
of the LONGVARCHAR column is 4486 and it is able to read it completely. It
is not truncated to 4096.

Faw