Home
 

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