[freetds] SP parameter cannot return more than 256 chars

Federico Alves sales at minixel.com
Sun Nov 30 10:57:32 EST 2008


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.




More information about the FreeTDS mailing list