Skip to Content.
Sympa Menu

freetds - Re: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.
  • Date: Wed, 15 Jan 2014 19:47:18 -0500

On Wed, 15 Jan 2014 11:26:03 +0200
Velichko Yuriy <velichko.yuriy AT gmail.com> wrote:

> dbsetopt( conn, DBTEXTLIMIT, "2,147,483,647", -1 );
>
> But these function return FAIL, and have no affect. The returned
> length still 4096.

If you look for that symbol in dblib.c, you'll see it's not
implemented. The function writes a message to the log and returns
fail. It doesn't call the error handler because there's no official
message for "not implemented".

The string "2,147,483,647" would not work in any case; commas would
interfere with converting it to an integer.

You can achieve the same effect by sending

SET TEXTSIZE 2147483647

or I bet

SET TEXTSIZE power(2,31)

would work, too.

It also wouldn't be hard nowadays to fix dbsetopt(), should you be so
inclined. :-)

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page