The following table shows the mapping of java.sql.Types to SQL
types.
Mapping of java.sql.Types
to SQL types
This table lists the java.sql.Types and shows how they map to SQL types.
java.sql.Types
SQL Types
BIGINT
BIGINT
BINARY
CHAR FOR BIT DATA
BLOB
BLOB
BOOLEAN
BOOLEAN
CHAR
CHAR
CLOB
CLOB
DATE
DATE
DECIMAL
DECIMAL
DOUBLE
DOUBLE PRECISION
FLOAT
DOUBLE PRECISION1
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
SQLXML2
XML
TIME
TIME
TIMESTAMP
TIMESTAMP
VARBINARY
VARCHAR FOR BIT DATA
VARCHAR
VARCHAR
- 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.
- SQLXML is only valid in JDBC 4.0 and later environments. SQLXML
corresponds to the SQL type XML in .
However, does not
recognize the java.sql.Types.SQLXML data type and does not support any JDBC-side
operations for the XML data type. Support for XML and the related operators
is implemented only at the SQL layer. See XML
data types for more.