15.7.2 Data types and accessories used by a UAP

Table 15-5 lists the data types that are set in the Value property of the HiRDBParameter class, for example during execution of the INSERT and GetXXXX methods of the HiRDBDataReader class that are used during execution of SELECT. Note that HiRDB's NULL is represented by DBNull.Value of the .NET Framework type.

Table 15-5 Data types and accessories for HiRDB-type UAPs

ClassificationHiRDB data type.NET Framework type used by UAPs, for example in INSERTAccessory used by UAP for SELECT
CharacterCHAR[ACTER]StringGetString()
VARCHAR/CHAR[ACTER]VARYINGStringGetString()
NCHAR/NATIONAL CHAR[ACTER]StringGetString()
NVARCHAR/NCHAR VARYINGStringGetString()
MCHARStringGetString()
MVARCHARStringGetString()
Numeric value[LARGE]DEC[IMAL]/NUMERICDecimalGetDecimal()
SMALLINTInt16GetInt16()
INT[EGER]Int32GetInt32()
SMALLFLT/REALSingleGetFloat()
FLOAT/DOUBLE PRECISIONDoubleGetDouble()
Date and timeDATEDateTimeGetDateTime()
TIMEDateTimeGetDateTime()
TIMESTAMPDateTimeGetDateTime()
OtherBINARYByte[]GetBytes()
BLOBByte[]GetBytes()
INTERVAL YEAR TO DAYStringGetString()
INTERVAL HOUR TO SECONDTimeSpanGetString()