[freetds] Fwd: dbrpcparam and varchar(max) column

Joshua Lang joshua.h.lang at gmail.com
Mon Mar 7 13:45:10 EST 2016

I ran into this same problem a few months back:

A workaround is to use the TEXT type (SYBTEXT) instead. I haven't
extensively tested it, but it seems to work for the basic cases I have
tested, such as yours.

On Tue, Mar 1, 2016 at 1:46 AM, Igor Anić <igor.anic at gmail.com> wrote:

> I'have stored procedure with output param of datatype varchar(max) and
> can't find the way to pass string longer than 8000 characters.
> Setting 5th parameter in dbrpcparam (maxlen) to value greater then 8000 has
> no effect. In sql server profiler varchar is always declared with max 8000
> in size. Setting maxlen to 0 has the same effect.
> From profiler:
> declare @p1 varchar(8000)
> set @p1=' ... '
> exec test_sp_varchar_max @p1=@p1 output
> select @p1
> What is the right way to use stored procedures with varchar(max) datatype.
> Thanks,
> Igor.
> dbrpcparam reference:
> http://www.freetds.org/reference/a00342.html#ga98b9b5db66975dafae8d422218e4de45
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

More information about the FreeTDS mailing list