Skip to Content.
Sympa Menu

freetds - Re: [freetds] SP parameter cannot return more than 256 chars

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SP parameter cannot return more than 256 chars
  • Date: Sun, 30 Nov 2008 17:22:08 +0100

Il giorno dom, 30/11/2008 alle 10.57 -0500, Federico Alves ha scritto:
> Freetds has a bug or a limitation
> I execute this query on tsql:
> "declare @iplist varchar(512),@z int exec tempdb.dbo.sip_redirect 44,
> @iplist out, @z out select @iplist,@z"
> but I only get back the first 256 characters on the variable @iplist, the
> rest is ignored, but I need the full 512 or more characters. How can we fix
> this limitation?
> I use the latest stable version. Parameter passing should be limited I guess
> to 64 K if possible.
>

Hi,
are you sure you are using the proper protocol version ?? I got
correct reply using 8.0 and 7.0, not using 4.2.

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page