Mapping for casts
The following table shows the mapping supported between the type defined for the ifxtype parameter in the UDTMetaData.setXXXCast() methods and SQL data types in the server.
| ifxtype parameter type from com.informix.lang.IfxTypes | HCL OneDB™ data type |
|---|---|
| IFX_TYPE_CHAR | CHAR |
| IFX_TYPE_SMALLINT | SMALLINT |
| IFX_TYPE_INT | INT |
| IFX_TYPE_FLOAT | FLOAT |
| IFX_TYPE_SMFLOAT | SMALLFLOAT |
| IFX_TYPE_DECIMAL | DECIMAL |
| IFX_TYPE_SERIAL | SERIAL |
| IFX_TYPE_DATE | DATE |
| IFX_TYPE_MONEY | MONEY |
| IFX_TYPE_DATETIME | DATETIME |
| IFX_TYPE_BYTE | BYTE |
| IFX_TYPE_TEXT | TEXT |
| IFX_TYPE_VARCHAR | VARCHAR |
| IFX_TYPE_INTERVAL | INTERVAL |
| IFX_TYPE_NCHAR | NCHAR |
| IFX_TYPE_NVARCHAR | NVARCHAR |
| IFX_TYPE_INT8 | INT8 |
| IFX_TYPE_SERIAL8 | SERIAL8 |
| IFX_TYPE_LVARCHAR | LVARCHAR |
| IFX_TYPE_SENDRECV | SENDRECV |
| IFX_TYPE_BOOL | BOOLEAN |
| IFX_TYPE_IMPEXP | IMPEXP |
| IFX_TYPE_IMPEXPBIN | IMPEXPBIN |
| IFX_TYPE_CLOB | CLOB |
| IFX_TYPE_BLOB | BLOB |