IfxType enumeration
This enumerator is used with the IfxParameter object. Each member represents a data type that is supported by HCL Informix® database servers. The following table shows all of the members and how each maps to .NET DbType types and to .NET Framework types. For detailed information about Informix® types, see the Informix® Guide to SQL: Reference.
Member | .NET DbType (best fit) | .NET Framework type (best fit) |
---|---|---|
Bigint | Int64 | Int64 |
BigSerial | Int64 | Int64 |
Blob | Binary | Byte[] |
Boolean | Boolean | Boolean |
Byte | Binary | Byte[] |
Char | StringFixedLength | String |
Char1 | StringFixedLength | Char |
Clob | String | String |
Date | Date | DateTime |
DateTime | DateTime | DateTime |
Decimal | Decimal | Decimal |
Float | Double | Double |
Int8 | Int64 | Int64 |
Integer | Int32 | Int32 |
IntervalDayFraction | String | TimeSpan |
IntervalYearMonth | String | String |
List | String | String |
LVarChar | String | String |
Money | Currency | Decimal |
MultiSet | String | String |
NChar | StringFixedLength | String |
NVarChar | String | String |
Row | String | String |
Serial | Int32 | Int32 |
Serial8 | Int64 | Int64 |
Set | String | String |
SmallFloat | Single | Single |
SmallInt | Int16 | Int16 |
SmartLOBLocator | Binary | Byte[] |
Text | String | String |
VarChar | String | String |