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: Velichko Yuriy <velichko.yuriy AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.
  • Date: Thu, 16 Jan 2014 23:04:44 +0200

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 <jklowden AT freetds.org> wrote:

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



--
Best Regards!




Archive powered by MHonArc 2.6.24.

Top of Page