Binary data being truncated to 8000 bytes when persisting to varbinary(MAX) - Sql Server 2008

Description

Hi

After upgrading from NHibernate 2.1 to 3.1.0 I appear to have hit a regression that was marked as fixed in version 3.1.0, refer [#NH-2484].

All attempts to persist binary data exceeding 8k to varbinary(MAX) results in the data being truncated, all worked well using version 2.1, unfortunately upgrading to 3.1.0 has introduced this truncation issue.

No exception is thrown and no indication is given that the attempt to serialize the binary data to varbinary(MAX) table column has occured.

Attachment provided illustrates the issue.

Environment

None

Attachments

1

Activity

Julian Maughan 
June 12, 2011 at 6:16 AM

The fluent mapping in your repro doesn't provide any type information to tell NH that you are mapping a Blob. I believe a 'byte[]' type is interpreted as a BinaryType which has a default max length of 8000. Try setting an explicit type of BinaryBlobType and/or setting the length to a value larger than 8000 bytes.

Note that addresses a slightly different problem, where the type was defined (a serializable type), but the specified length was ignored.

Not an Issue

Details

Assignee

Reporter

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created June 10, 2011 at 6:20 AM
Updated October 28, 2012 at 5:18 PM
Resolved June 12, 2011 at 2:51 PM
Who's Looking?