JDBC SQL Types

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