FreeTDS Development Group

[William.P.McGonigle AT artoo.hitchcock.org (William P. McGonigle)]

--- "Tim" wrote:
Does the FreeTDS JDBC Driver support strings larger than 4,096 characters?

I have been accessing a MS SQL Server 7 database from a linux java
application that is reading a TEXT column from a table.
--- end of quote ---

A few past  messages:

-Bill

--- Forwarded Message from "Michael Suedkamp" <ms AT suedkm.franken.de> ---

>Date: Mon, 7 Feb 2000 9:35:45
>Subject: [freetds] Re: maximum string length
>To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
>From: "Michael Suedkamp" <ms AT suedkm.franken.de>
>List-Unsubscribe: <mailto:$subst('Email.Unsub')>
>List-Software: Lyris Server version 3.0
>List-Subscribe: <mailto:subscribe-freetds AT franklin.oit.unc.edu>
>List-Owner: <mailto:owner-freetds AT franklin.oit.unc.edu>
>Reply-To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
>Sender: bounce-freetds-95974 AT franklin.oit.unc.edu
>Precedence: bulk

Hi Brian,

according to the MS SQL Server doc the default textsize is 4096 bytes and a 
'SELECT @@TEXTSIZE' prooved that. Maybe I should give TDS 7.0 a try because 
our MS SQL Server is a version 7.


======



--- Forwarded Message from Brian Bruns <camber AT umcc.ais.org> ---

>Date: Sun, 6 Feb 2000 21:38:07 -0500 (EST)
>From: Brian Bruns <camber AT umcc.ais.org>
>To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
>Subject: [freetds] Re: maximum string length
>In-Reply-To: 
><LYR12294-36379-2000.02.06-13.44.51--camber#ais.org AT franklin.oit.unc.edu>
>List-Unsubscribe: <mailto:$subst('Email.Unsub')>
>List-Software: Lyris Server version 3.0
>List-Subscribe: <mailto:subscribe-freetds AT franklin.oit.unc.edu>
>List-Owner: <mailto:owner-freetds AT franklin.oit.unc.edu>
>Reply-To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
>Sender: bounce-freetds-95974 AT franklin.oit.unc.edu
>Precedence: bulk

Hmmm...you may need to issue a 'set textsize 4000' or some such prior to
issuing your query...I don't know the default textsize for MS SQL off the
top of my head.

Brian