[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5857) SQLServer dialect for varbinary incorrect for 2008

[Steve Mactaggart (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=39722#action_39722 ] 

Steve Mactaggart commented on HHH-5857:
---------------------------------------

I did try and search for the issue before logging this, but it seems that issue is talking about VARCHAR and the MAX scale.
My issue is with the Mapping of VARBINARY to IMAGE which is outdated.

I will download the 3.6.1-SNAPSHOT and see what I get.

> SQLServer dialect for varbinary incorrect for 2008
> --------------------------------------------------
>
>                 Key: HHH-5857
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5857
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.6.0
>            Reporter: Steve Mactaggart
>
> In SQLServer 2008 the IMAGE data type has been deprecated and replaced with VARBINARY(MAX)
> {quote}
> ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. For more information, see Using Large-Value Data Types.
> {quote}
> The current SQLServer2008Dialect has the mapping (inherirted from SQLServerDialect):
> {code}
> 		registerColumnType( Types.VARBINARY, "image" );
> {code}
> This needs to be reverted to use VARBINARY.
> {code}
> 		registerColumnType( Types.VARBINARY, "varbinary" );
> {code}
> The issue is identified when using hibernate.ddl.auto=validate, it shows an error such as:
> {quote}
> Wrong column type in Database.dbo.BINARY_OBJECT for column BYTES. Found: varbinary, expected: image
> {quote}
> for an annotated fields such as:
> {code}
>     @Column(name = "BYTES", length = 100000, nullable = true)
>     private byte[] bytes;
> {code}

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