Home |
Previous Page | Next Page Appendix C. Mapping Data Types > Data Type Mapping for UDT Manager and UDR Manager >
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
- Informix 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_NVCHAR
- NVCHAR
- 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
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]