column data types

The following table describes the column data types.

Column data type Description
rdTypeCHAR Fixed-length character string. Length set by Size property.
rdTypeNUMERIC Signed, exact, numeric value with precision p and scale s (1 ≤ p ≤15; 0 ≤ s ≤ p).
rdTypeDECIMAL Signed, exact, numeric value with precision p and scale s (1 ≤ p ≤15; 0 ≤ s ≤ p).
rdTypeINTEGER Signed, exact numeric value with precision 10, scale 0 (signed: -2^31 ≤ n ≤ 2^31-1; unsigned:  0 ≤ n ≤ 2^32-1).
rdTypeSMALLINT Signed, exact numeric value with precision 5, scale 0 (signed: -32,768 ≤ n ≤ 32,767, unsigned: 0 ≤ n ≤ 65,535).
rdTypeFLOAT Signed, approximate numeric value with mantissa precision 15 (zero or absolute value 10^-308 to 10^308).
rdTypeREAL Signed, approximate numeric value with mantissa precision 7 (zero or absolute value 10^-38 to 10^38).
rdTypeDOUBLE Signed, approximate numeric value with mantissa precision 15 (zero or absolute value 10^-308 to 10^308).
rdTypeDATE Date — data source dependent.
rdTypeTIME Time — data source dependent.
rdTypeTIMESTAMP TimeStamp — data source dependent.
rdTypeVARCHAR Variable-length character string. Maximum length is the value returned by the Size property.
rdTypeLONGVARCHAR Variable-length character string. Maximum length determined by data source.
rdTypeBINARY Fixed-length binary data. Maximum length is the value returned by the Size property.
rdTypeVARBINARY Variable-length binary data. Maximum length 255.
rdTypeLONGVARBINARY Variable-length binary data. Maximum data source dependent.
rdTypeBIGINT Signed, exact numeric value with precision 19 (signed) or 20 (unsigned), scale 0 (signed: -2^63 ≤ n ≤ 2^63-1; unsigned: 0 ≤ n ≤ 2^64-1).
rdTypeTINYINT Signed, exact numeric value with precision 3, scale 0 (signed: -128 ≤ n ≤ 127, unsigned: 0 ≤ n ≤ 255).
rdTypeBIT Single binary digit.