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" );
}
|