Hi we're using NH2.0 and MSSQL 2005 and using SchemaExport to generate out DB creation scripts.

One column contains image data and is defined as:

<property name="ImageData" column="ImageData" type="BinaryBlob">

The resulting SQL is generated as:

ImageData VARBINARY(8000) null,


Instead of VARBINARY(MAX) as I'd expect. Nothing I do to the xml seems to affect how the sql type is generated.

Any ideas? Thanks

Have you tried adding sql-type="VARBINARY(MAX)" ?

Tried that and it didn't work.
Had to specify length=2147383647 which seems redundant on a BinaryBlob, it seems like a bug in schemaexport that it's not mapping BinaryBlob to the correct length varbinary