Java-to-SQL Type Conversion

From InterBase
Jump to: navigation, search

Go Up to InterClient/JDBC Compliance Specifications


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

Java-to-SQL type conversions
Java Type maps to getObject/setObject JDBC SQL Type

java.lang.String

VARCHAR, LONGVARCHAR

java.lang.Bignum

NUMERIC

short

java.lang.Integer

SMALLINT

int

java.lang.Integer

INTEGER

float

java.lang.Float

REAL

double

java.lang.Double

DOUBLE

byte[]

VARBINARY, LONGVARBINARY

java.sql.Date

DATE

c.sql.Time

TIME

java.sql.Timestamp

TIMESTAMP

Advance To: