Hi,

We are using Hibernate with a Firebird and a MS SQL server database and we want to use large binary fields with the java type byte[](which is prefered over java.sql.Blob according to 'Hibernate in Action'), so we have chosen the hibernate type 'Binary'

When we generate a schema for Firebird it creates a nice BLOB field for the data, which is fine, because it's unlimited in length. However for SQL server the SchemaExport creates a Varbinary field, which has a limited length of 8,000 characters.

I know that I can override the translation from Binary to varbinary by setting the sql-type property to 'IMAGE' in the mapping file, but if I do this then SchemaExport will also try to create an IMAGE datatype for firebird, which is inpossible...

Any hints on how to solve this?