Re: How to increase DBTEXTSIZE and DBTEXTSIZE.

Thanks for reply!
SET TEXTSIZE - works as expected.

But, of course will be great, if you implement "API way"!

On 16 January 2014 02:47, James K. Lowden <[email protected]> wrote:

> 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
Best Regards!