apache.org > db > ddlutils |
Interbase
DdlUtils supports Interbase version 7.0 and above.
Platform identifier:
- Interbase
Recognized JDBC driver:
- interbase.interclient.Driver
Recognized JDBC sub protocol:
- jdbc:interbase
The database supports SQL comments | yes |
The database supports delimited identifiers | yes |
The database's maximum identifier length | 31 |
The database supports default values for LONG types | yes |
DdlUtils uses sequences for identity columns | sort-of, DdlUtils uses a GENERATOR |
The database supports non-primary key columns as identity columns | yes |
The database allows INSERT/UPDATE statements to set values for identity columns | yes |
DdlUtils can read back the auto-generated value of an identity column | yes |
The database supports non-unique indices | yes |
DdlUtils can create a database via JDBC | no |
DdlUtils can drop a database via JDBC | no |
JDBC Type | Database Type | Additional comments |
---|---|---|
ARRAY | BLOB | Will be read back as LONGVARBINARY |
BIGINT | NUMERIC(18,0) | |
BINARY | BLOB | We could use CHAR(n) CHARACTER SET OCTETS but the JDBC driver
cannot handle these types properly. Will be read back as LONGVARBINARY |
BIT | SMALLINT | Interbase has no native boolean type Will be read back as SMALLINT |
BLOB | BLOB | Will be read back as LONGVARBINARY |
BOOLEAN | SMALLINT | Interbase has no native boolean type Will be read back as SMALLINT |
CHAR | CHAR | |
CLOB | BLOB SUB_TYPE TEXT | |
DATALINK | BLOB | Will be read back as LONGVARBINARY |
DATE | DATE | |
DECIMAL | DECIMAL | |
DISTINCT | BLOB | Will be read back as LONGVARBINARY |
DOUBLE | DOUBLE PRECISION | |
FLOAT | DOUBLE PRECISION | Will be read back as DOUBLE |
INTEGER | INTEGER | |
JAVA_OBJECT | BLOB | Will be read back as LONGVARBINARY |
LONGVARBINARY | BLOB | |
LONGVARCHAR | BLOB SUB_TYPE TEXT | Will be read back as CLOB |
NULL | BLOB | Will be read back as LONGVARBINARY |
NUMERIC | NUMERIC | |
OTHER | BLOB | Will be read back as LONGVARBINARY |
REAL | FLOAT | |
REF | BLOB | Will be read back as LONGVARBINARY |
SMALLINT | SMALLINT | |
STRUCT | BLOB | Will be read back as LONGVARBINARY |
TIME | TIME | |
TIMESTAMP | TIMESTAMP | |
TINYINT | SMALLINT | Will be read back as SMALLINT |
VARBINARY | BLOB | We could use VARCHAR(n) CHARACTER SET OCTETS but the JDBC driver
cannot handle these types properly. Will be read back as LONGVARBINARY |
VARCHAR | VARCHAR |