[freetds] Question about MAX param size when calling StoredProc

Navdeep Shergill jatshergill at gmail.com
Wed May 21 12:26:55 EDT 2008


Microsoft states that they are going to EOL 'image' data type in future
versions. They expect us to use varbinary(max). Any chance of it being
supported in FreeTDS?

On Wed, May 21, 2008 at 7:51 AM, Robert G. Davis <rdavis at unico.com> wrote:

> SQL 2005 includes varbinary(max) which allows up to 2GB.  Also for
> VARCHAR and NVARCHAR.
>
> Rob..
>
> On Tue, 2008-05-20 at 18:12 -0400, James K. Lowden wrote:
> > Navdeep Shergill wrote:
> > > so does that mean that using FreeTDS I can only send a max 8k param
> > > lenght for Varbinary?
> >
> > Cf. http://msdn.microsoft.com/en-us/library/aa258271(SQL.80).aspx<http://msdn.microsoft.com/en-us/library/aa258271%28SQL.80%29.aspx>
> >
> > BINARY and VARBINARY types are restricted to 8000 bytes.  I am pleased to
> > hear VARBINARY works as expected.
> >
> > Microsoft SQL Server 2000 allows stored procedures to define parameters
> of
> > type TEXT or IMAGE.  I'd expect them to work with FreeTDS nowadays, but
> > the src/dblib/rpc.c unit test, for instance, doesn't use those types.  If
> > you try them, I'd be interested to hear back, either way.
> >
> > --jkl
> >
> >
> > >
> > > On Tue, May 20, 2008 at 5:22 AM, James K. Lowden <jklowden at freetds.org
> >
> > > wrote:
> > >
> > > > Navdeep Shergill wrote:
> > > > > I am trying to call to call a
> > > > > storedProc on a SQL2005 server that takes in a 'varbinary' field as
> > > > > input paramter. The varbinary field is set up with '-1' as the
> > > > > Length in the database.
> > > >
> > > > varbinary is the weirdest datatype in the library, perhaps on the
> > > > planet. I have found places where Microsoft claims to use it, but in
> > > > fact doesn't.
> > > >
> > > >
> > > > Can I ask why you're using it?  Would TEXT/BINARY do just as well?
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



More information about the FreeTDS mailing list