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 HCL Informix Guide to SQL: Reference.

Table 1. IfxType enumeration
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