Skip to Content.
Sympa Menu

freetds - Re: [freetds] Question about MAX param size when calling StoredProc

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Navdeep Shergill" <jatshergill AT gmail.com>
  • To: rdavis AT unico.com, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Question about MAX param size when calling StoredProc
  • Date: Wed, 21 May 2008 09:26:55 -0700

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
>




Archive powered by MHonArc 2.6.24.

Top of Page