[freetds] Fwd: dbrpcparam and varchar(max) column
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.
> dbrpcparam reference:
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS