freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Question about MAX param size when calling StoredProc
Date: Tue, 20 May 2008 08:22:18 -0400

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?

--jkl

[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, Navdeep Shergill, 05/21/2008