Mapping of java.sql.Types to SQL types

Mapping of java.sql.Types to SQL Types shows the mapping of java.sql.Types to SQL types.

Table 1. 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.