|
TINYINT |
SMALLINT |
INTEGER |
BIGINT |
REAL |
FLOAT |
DOUBLE |
DECIMAL |
NUMERIC |
BIT |
CHAR |
VARCHAR |
LONGVARCHAR |
BINARY |
VARBINARY |
LONGVARBINARY |
DATE |
TIME |
TIMESTAMP |
ARRAY |
BLOB |
CLOB |
STRUCT |
REF |
JAVA OBJECT |
String |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
java.math.BigDecimal |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
Boolean |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
Integer |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
Long |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
Float |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
Double |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
x |
|
|
|
|
|
|
|
|
|
|
|
|
byte[] |
|
|
|
|
|
|
|
|
|
|
|
|
|
x |
x |
x |
|
|
|
|
|
|
|
|
|
java.sql.Date |
|
|
|
|
|
|
|
|
|
|
x |
x |
x |
|
|
|
x |
|
x |
|
|
|
|
|
|
java.sql.Time |
|
|
|
|
|
|
|
|
|
|
x |
x |
x |
|
|
|
|
x |
|
|
|
|
|
|
|
java.sql.Timestamp |
|
|
|
|
|
|
|
|
|
|
x |
x |
x |
|
|
|
x |
x |
x |
|
|
|
|
|
|
Array |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
x |
|
|
|
|
|
Blob |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
x |
|
|
|
|
Clob |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
x |
|
|
|
Struct |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
x |
|
|
Ref |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
x |
|
Java class |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
x |