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 09:15:43 -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





Archive powered by MHonArc 2.6.24.

Top of Page