FreeTDS Development Group

["Spectron Caribe, Inc." <spectron AT caribe.net>]

If you are referring about the JDBC driver it is a bug. A easily fixed bug
that I donn't know why hasnt been fixed yet. Is just changing one line in
Connection_base.java from this:

protected String sqlStatementToInitialize(){
  return serverType==Tds.SYBASE ? "set quoted_identifier on set textsize
50000" : "";
}

To this:

protected String sqlStatementToInitialize(){
  return("set quoted_identifier on set textsize 50000");
}

Personally I would allow the user to set the text size in the URL as set it
as a property , if its not found use the default (50000) for both, Sybase
and MS SQL. I posted this change here but I couldn't find the message in the
mailing list. Is the JDBC driver being updated at all? There hasn't been a
change in the snapshots since march.

Faw

----- Original Message -----
From: "Lance" <hobbyman AT zdnetonebox.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Monday, July 09, 2001 12:09 PM
Subject: [freetds] MSSQL text field - 4096 limit


>
>  I have just recently found that a text field will
>  only return a maximum of 4096 characters.
>
>  What is the thinking behind this limit? Are there
>  any problems with bumping that up to say 8192?
>
> lance
>
> ___________________________________________________________________
> To get your own FREE ZDNet Onebox - FREE voicemail, email, and fax,
> all in one place - sign up today at http://www.zdnetonebox.com
>
>
> ---
> You are currently subscribed to freetds as: [spectron AT caribe.net]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>