[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2669) Unequivocally map MySQL LOB types to the LONG variant

[Gail Badner (JIRA)]

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

Gail Badner commented on HHH-2669:
----------------------------------

Mark, I noticed that the fix to MySQLDialect.java commented out:

// registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
// registerColumnType( Types.VARCHAR, 65535, "text" );

but did not comment out the following:

registerColumnType( Types.VARBINARY, 16777215, "mediumblob" );
registerColumnType( Types.VARBINARY, 65535, "blob" );

Should these also be commented out? 

> Unequivocally map MySQL LOB types to the LONG variant
> -----------------------------------------------------
>
>                 Key: HHH-2669
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2669
>             Project: Hibernate Core
>          Issue Type: Improvement
>          Components: core
>            Reporter: Steve Ebersole
>            Assignee: Steve Ebersole
>             Fix For: 3.3.0.CR1
>
>
> MySQL differentiates different "sizes" of LOBs.  Apparently, the smaller types offer no storage benefit nor performance gain.  So we should consider mapping the LOB types in the MySQL dialect to the LON variants in all cases.  
> The current setup causes truncation headaches for users, apparently unnecessarily.

-- 
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