Support for MySQL5 new varchar length ------------------------------------- Key: HHH-1372 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1372 Project: Hibernate Core Issue Type: New Feature Components: core Affects Versions: 3.1 Environment: Hibernate 3, MySQL5 Reporter: Marc Batchelor Assignee: Steve Ebersole Fix For: 3.1.2 MySQL5 now supports varchars at 65535 characters. There should probably be a specific Mysql5 dialect to handle this difference between MySql4 and MySql5. The code change: The constructor currently has these lines for the VARCHAR type: ... registerColumnType( Types.VARCHAR, "longtext" ); registerColumnType( Types.VARCHAR, 16777215, "mediumtext" ); registerColumnType( Types.VARCHAR, 65535, "text" ); registerColumnType( Types.VARCHAR, 255, "varchar($l)" ); ... For MySql5, this section should look like this: ... registerColumnType( Types.VARCHAR, "longtext" ); //$NON-NLS-1$ registerColumnType( Types.VARCHAR, 16777215, "mediumtext" ); //$NON-NLS-1$ registerColumnType( Types.VARCHAR, 65535, "varchar($l)" ); //$NON-NLS-1$ ... It would be pretty handy if the Dialect had an unRegisterColumnType. Then, MySQL5Dialect could subclass MySQLDialect. The constructor could call the super, then unregister the VARCHAR types and re-register 'em as desired. But that's another topic.