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