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
|
|
Advance To: