Skip to Content.
Sympa Menu

freetds - Re: Does the FreeTDS JDBC Driver support...?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: William.P.McGonigle AT artoo.hitchcock.org (William P. McGonigle)
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Does the FreeTDS JDBC Driver support...?
  • Date: 24 Feb 2000 13:25:11 EST


--- "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




Archive powered by MHonArc 2.6.24.

Top of Page