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