shows the 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 FLOATFLOAT data typejava.sql type converted to DOUBLE PRECISION when retrieved DOUBLE PRECISION² INTEGER INTEGER LONGVARBINARYLONGVARBINARY LONG VARCHAR FOR BIT DATA LONGVARCHARLONGVARCHAR 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

1. Mappingof SQL types to java.sql.TypesBIT is only valid in JDBC 2.0 and earlier environments.
2. 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.