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: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Question about MAX param size when calling StoredProc
  • Date: Thu, 22 May 2008 08:41:37 -0700

Thanks for your help James. We will go ahead and use IMAGE for now.

Keep up the great work

On Wed, May 21, 2008 at 12:39 PM, James K. Lowden <jklowden AT freetds.org>
wrote:

> Navdeep Shergill wrote:
> > 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?
>
> Chance, yes. Soon, no.
>
> Cf. the ML "row problem" thread in March 2008. varchar(max) has a
> different protocol representation and breaks important assumptions in the
> libtds data structures. It's not an easy thing to support. Someone more
> paranoid than I am would sense a diabolical purpose....
>
> But don't fret about deprecation; the wind's at your back. It's a safe
> bet FreeTDS will support varchar(max) and varbinary(max) a long time
> before Micrsoft drops support for TEXT and IMAGE. They're still present
> in SQL Server 2008.
>
> Other than "vendor guidance" is there any reason to use varbinary(max)
> over IMAGE?
>
> --jkl
> _______________________________________________
> 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