Mapping of java.sql.Types to SQL types In , the java.sql.Types are mapped to SQL data types. java.sql.Typesmapped to SQL types SQL typesmapped to java.sql.Types JDBC typesmapped to SQL typesfor JDBC and SQL typesdata typesJDBC types to SQL typesjava.sql.TypesLONGVARBINARY java.sql.TypesLONGVARCHARjava.sql.TypesFLOAT data type

The following table shows the mapping of java.sql.Types to SQL types.

Mapping of <i>java.sql.Types</i> to SQL typesThis 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
  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.
  2. 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.