SQL2005 and VarBinary(MAX)

Mar 3, 2010 at 9:32 PM

I'm trying to create a table in nHydrate that has a column type of varbinary(max).  When the SQLServerType is set to 2005, it throws an error:  "The length (max) setting is not supported in the target version of SQL Server."  When I switch the type to 2008, the error goes away, but I figure that'll probably break something since we're still running 2005.  As far as I know, the varbinary(max) type is perfectly legit in 2005.  Any ideas?

Mar 4, 2010 at 10:48 AM
Edited Mar 4, 2010 at 10:50 AM

You are right. The error exists and SQL 2005 supports VARBINARY(MAX).

The question is not new to this discussion forum, it was asked also in the past. See http://nhydrate.codeplex.com/Thread/View.aspx?ThreadId=155631 for other data types.

The developer have seen and recognized the error as you can read and will be fixed in the next realease. So probably he is going to fix it for the rest data types supporting the MAX keyword. My opinion...

Thank you.

Mar 6, 2010 at 7:01 PM

The latest post has support for the MAX length type in 2005. Please download and look.