The IfxTypes class
The extended IfmxPreparedStatement methods require you to pass in the HCL Informix® data type to which you want to map. These types are part of the com.informix.lang.IfxTypes class.
The following table shows the IfxTypes constants and the corresponding Informix® data types.
| IfxTypes constant | Informix® data type |
|---|---|
| IfxTypes.IFX_TYPE_BIGINT | BIGINT |
| IfxTypes.IFX_TYPE_BIGSERIAL | BIGSERIAL |
| IfxTypes.IFX_TYPE_CHAR | CHAR |
| IfxTypes.IFX_TYPE_SMALLINT | SMALLINT |
| IfxTypes.IFX_TYPE_INT | INT |
| IfxTypes.IFX_TYPE_FLOAT | FLOAT |
| IfxTypes.IFX_TYPE_SMFLOAT | SMALLFLOAT |
| IfxTypes.IFX_TYPE_DECIMAL | DECIMAL |
| IfxTypes.IFX_TYPE_SERIAL | SERIAL |
| IfxTypes.IFX_TYPE_DATE | DATE |
| IfxTypes.IFX_TYPE_MONEY | MONEY |
| IfxTypes.IFX_TYPE_NULL | NULL |
| IfxTypes.IFX_TYPE_DATETIME | DATETIME |
| IfxTypes.IFX_TYPE_BYTE | BYTE |
| IfxTypes.IFX_TYPE_TEXT | TEXT |
| IfxTypes.IFX_TYPE_VARCHAR | VARCHAR |
| IfxTypes.IFX_TYPE_INTERVAL | INTERVAL |
| IfxTypes.IFX_TYPE_NCHAR | NCHAR |
| IfxTypes.IFX_TYPE_NVARCHAR | NVARCHAR |
| IfxTypes.IFX_TYPE_INT8 | INT8 |
| IfxTypes.IFX_TYPE_SERIAL8 | SERIAL8 |
| IfxTypes.IFX_TYPE_SET | SQLSET |
| IfxTypes.IFX_TYPE_MULTISET | SQLMULTISET |
| IfxTypes.IFX_TYPE_LIST | SQLLIST |
| IfxTypes.IFX_TYPE_ROW | SQLROW |
| IfxTypes.IFX_TYPE_COLLECTION | COLLECTION |
| IfxTypes.IFX_TYPE_UDTVAR | UDTVAR |
| IfxTypes.IFX_TYPE_UDTFIXED | UDTFIXED |
| IfxTypes.IFX_TYPE_REFSER8 | REFSER8 |
| IfxTypes.IFX_TYPE_LVARCHAR | LVARCHAR |
| IfxTypes.IFX_TYPE_SENDRECV | SENDRECV |
| IfxTypes.IFX_TYPE_BOOL | BOOLEAN |
| IfxTypes.IFX_TYPE_IMPEXP | IMPEXP |
| IfxTypes.IFX_TYPE_IMPEXPBIN | IMPEXPBIN |
| IfxTypes.IFX_TYPE_CLOB | CLOB |
| IfxTypes.IFX_TYPE_BLOB | BLOB |