I apologize if this has been answered already, but I’ve been searching for a reference of changelog column type to database-specific type and can’t find any.
I really just want to know the types that are mostly database independent. My project requires support for Oracle and Postgres and I want to make sure our changelogs being developed are compatible with both.
This is all I have found on database-independent types:
<span data types will be converted to the correct database implementation: * BOOLEAN * CURRENCY * UUID * CLOB * BLOB * DATE * DATETIME * TIME * BIGINT Also, specifying a java.sql.Types.* type will be converted to the correct type as well. If needed, precision can be included. * java.sql.Types.TIMESTAMP * java.sql.Types.VARCHAR(255)
I believe there used to be a table in the addcolumn documentation that gave me the information I’m looking for on the old web site. Something like this:
Type | Oracle | Postgres | etc…
Number | Number | Not Sup | …
If there is a reference like this, can someone point me to it? Thanks