[freetds] Question about MAX param size when calling StoredProc
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>
> 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?
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
More information about the FreeTDS