Font size:

java.sql.Types

Table 12 shows the mapping of java.sql.Types to SQL types.

Table 12. Mapping of java.sql.Types to SQL Types

java.sql.Types	SQL Types
BIGINT	BIGINT
BINARY	CHAR FOR BIT DATA
BIT¹	CHAR FOR BIT DATA
BLOB	BLOB (JDBC 2.0 and up)
CHAR	CHAR
CLOB	CLOB (JDBC 2.0 and up)
DATE	DATE
DECIMAL	DECIMAL
DOUBLE	DOUBLE PRECISION
FLOAT	DOUBLE PRECISION²
INTEGER	INTEGER
LONGVARBINARY	LONG VARCHAR FOR BIT DATA
LONGVARCHAR	LONG VARCHAR
NULL	Not a data type; always a value of a particular type
NUMERIC	DECIMAL
REAL	REAL
SMALLINT	SMALLINT
TIME	TIME
TIMESTAMP	TIMESTAMP
VARBINARY	VARCHAR FOR BIT DATA
VARCHAR	VARCHAR

Notes:

BIT is only valid in JDBC 2.0 and earlier environments.
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.