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

Classification	HiRDB data type	.NET Framework type used by UAPs, for example in INSERT	Accessory used by UAP for SELECT
Character	CHAR[ACTER]	String	GetString()
	VARCHAR/CHAR[ACTER]VARYING	String	GetString()
	NCHAR/NATIONAL CHAR[ACTER]	String	GetString()
	NVARCHAR/NCHAR VARYING	String	GetString()
	MCHAR	String	GetString()
	MVARCHAR	String	GetString()
Numeric value	[LARGE]DEC[IMAL]/NUMERIC	Decimal	GetDecimal()
	SMALLINT	Int16	GetInt16()
	INT[EGER]	Int32	GetInt32()
	SMALLFLT/REAL	Single	GetFloat()
	FLOAT/DOUBLE PRECISION	Double	GetDouble()
Date and time	DATE	DateTime	GetDateTime()
	TIME	DateTime	GetDateTime()
	TIMESTAMP	DateTime	GetDateTime()
Other	BINARY	Byte[]	GetBytes()
	BLOB	Byte[]	GetBytes()
	INTERVAL YEAR TO DAY	String	GetString()
	INTERVAL HOUR TO SECOND	TimeSpan	GetString()