LONGVARCHAR in freetds JDBC max size is 4096?
Spectron Caribe, Inc.
spectron at caribe.net
Mon May 7 10:23:45 EDT 2001
> ----- 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
More information about the FreeTDS
mailing list