User guide

10.8 JDBC Specification Java to SQL Datatype Mappings

Java Type SQL Type (from java.sql.Types)

boolean BIT

byte TINYINT

short SMALLINT

int INTEGER

long BIGINT

float REAL

double DOUBLE

java.math.BigDecimal NUMERIC

java.lang.String VARCHAR or LONGVARCHAR

byte[] VARBINARY or LONGVARBINARY

java.sql.Date DATE

java.sql.Time TIME

java.sql.Timestamp TIMESTAMP

java.sql.Blob BLOB

java.sql.Clob CLOB

Contents