Hello,

I use nhibernate 1.0.2.0 but I cannot persist byte[] when its size exceeds 8kb. I tried with image or varbinary(max) in the db (sql server 2005).

Everything works fine for small documents( < 8000 bytes).
In the mapping : <property name="Resume" column="RESUME"/>
Specifying the sql-type in the mapping has no effect.

I check the length with select len(resume) from Mytable and it returns 8000, even when I persist larger document.

Unfortunately upgrading to 1.2 is not really an option

Any idea ?

Thanks,

Gengis,

Try adding length="100000" as an attribute to the property element. I know this works with 1.2.

Map it as BinaryBlob (type="BinaryBlob")

Thanks ben, it works;