JDBC Reference
Page 15 of 31

java.sql.Types

Table 6-3 shows the mapping of java.sql.Types to SQL-J types.

Table 6-3 Mapping of java.sql.Types to SQL-J Types

java.sql.Types

SQL-J Types

BIGINT

LONGINT

BINARY

BIT

BIT

BOOLEAN

CHAR

CHAR

DATE

DATE

DECIMAL

DECIMAL

DOUBLE

DOUBLE PRECISION

FLOAT

DOUBLE PRECISION1

INTEGER

INTEGER

LONGVARBINARY

LONG VARBINARY

LONGVARCHAR

LONG VARCHAR

NULL

Not a data type; always a value of a particular type

NUMERIC

DECIMAL

OTHER

Java classes

REAL

REAL

SMALLINT

SMALLINT

TIME

TIME

TIMESTAMP

TIMESTAMP

TINYINT

TINYINT

VARBINARY

BIT VARYING

VARCHAR

VARCHAR

1
Values can be passed in using the FLOAT type code; however, these are stored as DOUBLE PRECISION values, and so always have the type code DOUBLE when retrieved.