Data type mapping between extended types and Java™ and JDBC types
JDBC type | Java™ object type | Informix® type |
---|---|---|
java.sql.Types.LONGVARCHAR | java.sql.String |
LVARCHAR |
java.sql.Types.JAVA_OBJECT | java.sql.SQLData | Opaque type |
java.sql.Types.LONGVARBINARY |
java.sql.Blob |
BLOB |
java.sql.Types.LONGVARCHAR |
java.sql.Clob |
CLOB |
java.sql.Types.LONGVARBINARY |
java.io.inputStream |
BYTE |
java.sql.Types.LONGVARCHAR |
java.io.InputStream |
TEXT |
java.sql.Types.JAVA_OBJECT |
java.sql.SQLData |
Named row |
java.sql.Types.STRUCT | java.sql.Struct | Unnamed row |
java.sql.Types.ARRAY |
java.sql.Array |
set, multiset |
java.sql.Types.ARRAY |
java.sql.Array |
LIST |
A Java™ boolean object can map to the Informix® smallint data type or the Informix® boolean data type. Informix® JDBC Driver attempts to map it according to the column type. However, in cases such as PreparedStatement host variables, Informix® JDBC Driver cannot access the column types, so the mapping is somewhat limited. For more details on data type mapping, see Data type mapping for PreparedStatement.setXXX() extensions.