[freetds] Question about MAX param size when calling StoredProc

Navdeep Shergill jatshergill at gmail.com
Thu May 22 11:41:37 EDT 2008


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
>



More information about the FreeTDS mailing list