Not all of the SQL types described by the JDBC specification are supported by DB2® for IBM® i.
Unsupported SQL Types
In the cases where a SQL type is not supported, the JDBC driver substitutes a similar SQL type.
The following table lists the SQL types that are not supported and the SQL type that JDBC driver substitutes for each.
| Unsupported SQL type | Substituted SQL type |
|---|---|
| BIT | SMALLINT |
| TINYINT | SMALLINT |
| LONGVARCHAR | VARCHAR |
| LONGVARBINARY | VARBINARY |