Reference | Help | Introduction | Slide Show | Class Hierarchy | InterClient
PREV | NEXT | FRAMES | NO FRAMES |  |

### JDBC to InterBase Native Type Mapping

Mapping from JDBC types to the preferred InterBase and Java types.
The driver converts between types according to the JDBC specification.

JDBC Type Name | InterBase Type Name | Java Type Name
CHAR(n) | CHAR(n) see note 1 | java.lang.String
VARCHAR(n) | VARCHAR(n) see note 1 | java.lang.String
LONGVARCHAR | BLOB SUB_TYPE TEXT see note 1 | String or java.io.InputStream
BINARY(n) | CHAR(n) CHARACTER SET BINARY | byte[]
VARBINARY(n) | VARCHAR(n) CHARACTER SET BINARY | byte[]
LONGVARBINARY | BLOB SUB_TYPE 0 | byte[] or java.io.InputStream
DATE | DATE see note 2 | java.sql.Date
TIME | DATE see note 2 | java.sql.Time
TIMESTAMP | DATE see note 2 | java.sql.Timestamp
SMALLINT | SMALLINT | short
INTEGER | INTEGER | int
REAL | FLOAT | float
DOUBLE | DOUBLE PRECISION | double
NUMERIC(p,s) | NUMERIC(p,s) | java.math.BigDecimal
DECIMAL(p,s) | DECIMAL(p,s) | java.math.BigDecimal
OTHER | ARRAY see note 3 | java.lang.Object

Note 1: See Character Set Support.

Note 2: An InterBase DATE stores both date and time down to the number of seconds since Jan 1, 100 AD. The precision stored is actually 10,000th of a second but sub-second times are not currently supported by InterClient.

Note 3: InterBase arrays are currently treated as binary blob data. Future releases of InterClient will add support for InterBase arrays as an extension to the JDBC API.

Reference | Help | Introduction | Slide Show | Class Hierarchy | InterClient
PREV | NEXT | FRAMES | NO FRAMES |  |

Send comments or suggestions to interclient@interbase.com