Does the FreeTDS JDBC Driver support...?
William P. McGonigle
William.P.McGonigle at artoo.hitchcock.org
Thu Feb 24 13:25:11 EST 2000
--- "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
More information about the FreeTDS
mailing list