freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Question about MAX param size when calling StoredProc
- From: "Robert G. Davis" <rdavis AT unico.com>
- To: 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:51:14 -0500
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
>
> 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] Question about MAX param size when calling StoredProc,
Navdeep Shergill, 05/20/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
James K. Lowden, 05/20/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
Navdeep Shergill, 05/20/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
James K. Lowden, 05/20/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
Robert G. Davis, 05/21/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
Navdeep Shergill, 05/21/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
James K. Lowden, 05/21/2008
- Re: [freetds] Question about MAX param size when calling StoredProc, Navdeep Shergill, 05/22/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
James K. Lowden, 05/21/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
Navdeep Shergill, 05/21/2008
- Re: [freetds] Question about MAX param size when calling StoredProc, Navdeep Shergill, 05/21/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
Robert G. Davis, 05/21/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
James K. Lowden, 05/20/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
Navdeep Shergill, 05/20/2008
-
Re: [freetds] Question about MAX param size when calling StoredProc,
James K. Lowden, 05/20/2008
Archive powered by MHonArc 2.6.24.