FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

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