IfxType enumeration
This enumerator is used with the IfxParameter object. Each member represents a data type that is supported by HCL OneDB™ 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 HCL OneDB types, see the HCL OneDB 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 |