[freetds] SP parameter cannot return more than 256 chars
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.
are you sure you are using the proper protocol version ?? I got
correct reply using 8.0 and 7.0, not using 4.2.
More information about the FreeTDS