Supported JDBC data types
The following table lists the supported Java™ data types for each JDBC data type.
| JDBC data type | Java data type | Length |
|---|---|---|
| ARRAY | java.lang.Array | Application-defined |
| BIGINT | long | 8 bytes |
| BINARY | byte[] | 1 - 32 KB |
| BIT | Boolean | 1 byte |
| CHAR | java.lang.String | 1 - 32 KB |
| CLOB | java.sql.Clob | Application-defined |
| DATE | java.sql.Date | Application-defined |
| DOUBLE | double | 8 bytes |
| FLOAT | float | 4 bytes |
| INTEGER | int | 4 bytes |
| PACKEDDECIMAL | java.math.BigDecimal | 1 - 10 bytes |
| SMALLINT | short | 2 bytes |
| STRUCT | java.lang.Struct | Application-defined |
| TIME | java.sql.Time | Application-defined |
| TIMESTAMP | java.sql.Timestamp | Application-defined |
| TINYINT | byte | 1 byte |
| ZONEDDECIMAL | java.math.BigDecimal | 1 - 19 bytes |