Home |
Previous Page | Next Page Appendix C. Mapping Data Types > Data Type Mapping for PreparedStatement.setXXX() Extensions >
The
extended IfmxPreparedStatement methods require
you to pass in the 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_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_NVCHAR
- NVCHAR
- 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
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]