Datatype Question

General Discussion
1

I currently have a column that uses the following SQL DDL definitions across the following databases.  Is there a liquibase type that I could use that would generate the proper sql when running the script?

DB2:  varchar(1024) for bit data
MSSQL:  varbinary(1024)
Oracle:  raw(1024)

2

There is “blob” which is converted to a database specific type, but it will be:
DB2: blob
MSSQL: VARBINARY(MAX)
Oracle: BLOB

With liquibase 2.0, you can create subclasses of DB2TypeConverter, MSSQLTypeConverter, and OracleTypeConverter and override the getBlobType() method to return the type you want.

Nathan