FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

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

On Fri, 4 May 2001, Spectron Caribe, Inc. wrote:

> I'm using MS SQL 6.5 and the latest snapshot from the freetds JDBC driver. I
> have a table that contains a TEXT column (CLOB). The problem is that if the
> length of the data in the field is greater than 4096 the driver  truncates
> the data over 4096. The driver says that TEXT columns that the data type of
> the column is LONGVARCHAR. Is this a limit programed somewhere in the driver
> or is it a bug?
> 
> Faw
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>