SQL-to-Java Type Conversions

Go Up to InterClient/JDBC Compliance Specifications

The following table shows the SQL-to-Java type conversion mapping.

SQL to Java type conversions

DBC SQL Type	Maps to Java Type	Or maps to Java objects returned/used by get/setObject methods
CHAR	java.lang.String
VARCHAR	java.lang.String
LONGVARCHAR	java.lang.String
NUMERIC	java.lang.Bignum
DECIMAL	java.lang.Bignum
SMALLINT	short	java.lang.Integer
INTEGER	int	java.lang.Integer
REAL	float	java.lang.Float
FLOAT	double	java.lang.Double
DOUBLE	double	java.lang.Double
BINARY	byte[]
VARBINARY	byte[]
LONGVARBINARY	byte[]
DATE	java.sql.Date
TIME	java.sql.Time
TIMESTAMP	java.sql.Timestamp