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. |