Skip to Content.
Sympa Menu

freetds - Re: MSSQL text field - 4096 limit

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Spectron Caribe, Inc." <spectron AT caribe.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: MSSQL text field - 4096 limit
  • Date: Mon, 9 Jul 2001 13:53:29 -0400


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





Archive powered by MHonArc 2.6.24.

Top of Page