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