[nhibernate-issues] [NHJIRA] Commented: (NH-2764) Binary data being truncated to 8000 bytes when persisting to varbinary(MAX) - Sql Server 2008

[Julian M. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21282#action_21282 ] 

Julian Maughan commented on NH-2764:
------------------------------------

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 NH-2484 addresses a slightly different problem, where the type was defined (a serializable type), but the specified length was ignored.

> Binary data being truncated to 8000 bytes when persisting to varbinary(MAX) - Sql Server 2008
> ---------------------------------------------------------------------------------------------
>
>                 Key: NH-2764
>                 URL: http://216.121.112.228/browse/NH-2764
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 3.1.0
>            Reporter: Brendan Cox
>            Priority: Critical
>         Attachments: ByteTruncationRepro.zip
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira