Message Title

HHH-9293

The behaviour of mysql is described in http://dev.mysql.com/doc/refman/5.6/en/column-count-limit.html
According to this it really would make sense to use varchar only up to 255 (or less) characters because the maximum row size is 65535 - where varchar counts but text not. So an improvement of the above would be:

 
                                                    	@Override
	protected void registerVarcharTypes() {
		registerColumnType( Types.VARCHAR, "longtext" );
		registerColumnType( Types.VARCHAR, 16777215/3, "mediumtext" ); // if UTF-8 tables are used, only 1/3 of the max length is available
        registerColumnType( Types.VARCHAR, 65535/3, "text" ); // if UTF-8 tables are used, only 1/3 of the max length is available
        registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
		registerColumnType( Types.LONGVARCHAR, "longtext" );
	}
 
                                                

Add Comment

This message was sent by Atlassian JIRA