Re: How to increase DBTEXTSIZE and DBTEXTSIZE.

"James K. Lowden" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
On Wed, 15 Jan 2014 11:26:03 +0200
Velichko Yuriy <[email protected]> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.