[freetds] SP parameter cannot return more than 256 chars

Frediano Ziglio freddy77 at gmail.com
Sun Nov 30 11:22:08 EST 2008


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), at z int exec tempdb.dbo.sip_redirect 44,
> @iplist out, @z out select @iplist, at 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





More information about the FreeTDS mailing list