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