freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.
- 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!
-
[freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.,
Velichko Yuriy, 01/15/2014
-
Re: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.,
James K. Lowden, 01/15/2014
- Re: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE., Velichko Yuriy, 01/16/2014
-
Re: [freetds] How to increase DBTEXTSIZE and DBTEXTSIZE.,
James K. Lowden, 01/15/2014
Archive powered by MHonArc 2.6.24.