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: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: LONGVARCHAR in freetds JDBC max size is 4096?
  • Date: Fri, 4 May 2001 20:53:00 -0400 (EDT)


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





Archive powered by MHonArc 2.6.24.

Top of Page