Skip to Content.
Sympa Menu

freetds - Re: LONGVARCHAR in freetds JDBC max size is 4096?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Spectron Caribe, Inc." <spectron AT caribe.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: LONGVARCHAR in freetds JDBC max size is 4096?
  • Date: Mon, 7 May 2001 10:23:45 -0400


> ----- 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





Archive powered by MHonArc 2.6.24.

Top of Page