[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:
http://lists.ibiblio.org/pipermail/freetds/2015q4/029664.html
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