[Hibernate-devel] MySQL dialect / schema generator

[Warwick B. <wb...@bt...>]

Hi guys... i've been playing around with storing images in MySQL using =
Hibernate - i had to make this change to store files larger than 255 =
bytes :


 public MySQLDialect() {
  super();
  register( Types.BIT, "BIT" );
  register( Types.BIGINT, "BIGINT" );
  register( Types.SMALLINT, "SMALLINT" );
  register( Types.TINYINT, "TINYINT" );
  register( Types.INTEGER, "INTEGER" );
  register( Types.CHAR, "CHAR(1)" );
  register( Types.VARCHAR, "TEXT" );
  register( Types.VARCHAR, 255, "VARCHAR($l)" );
  register( Types.FLOAT, "FLOAT" );
  register( Types.DOUBLE, "DOUBLE PRECISION" );
  register( Types.DATE, "DATE" );
  register( Types.TIME, "TIME" );
  register( Types.TIMESTAMP, "TIMESTAMP" );
  // Let the data be around 4MB
  //register( Types.VARBINARY, "BLOB" );
  //register( Types.VARBINARY, 255, "VARCHAR($l) BINARY" );
  register( Types.VARBINARY, "MEDIUMBLOB" );
 }