This documentation is archived and is not being maintained.
OdbcType Enumeration
.NET Framework 1.1
Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.
Specifies the data type of a field, property, for use in an OdbcParameter.
[Visual Basic] <Serializable> Public Enum OdbcType [C#] [Serializable] public enum OdbcType [C++] [Serializable] __value public enum OdbcType [JScript] public Serializable enum OdbcType
Remarks
The following table shows mappings between OdbcType data types, ODBC data types (shown in parentheses), and .NET Framework types.
Members
| Member name | Description |
|---|---|
| BigInt | Exact numeric value with precision 19 (if signed) or 20 (if unsigned) and scale 0 (signed: –2[63] <= n <= 2[63] – 1, unsigned:0 <= n <= 2[64] – 1) (SQL_BIGINT). This maps to Int64. |
| Binary | A stream of binary data (SQL_BINARY). This maps to an Array of type Byte. |
| Bit | Single bit binary data (SQL_BIT). This maps to Boolean. |
| Char | A fixed-length character string (SQL_CHAR). This maps to String. |
| Date | Date data in the format yyyymmdd (SQL_TYPE_DATE). This maps to DateTime. |
| DateTime | Date data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to DateTime. |
| Decimal | Signed, exact, numeric value with a precision of at least p and scale s, where 1 <= p <= 15 and s <= p. The maximum precision is driver-specific (SQL_DECIMAL). This maps to Decimal. |
| Double | Signed, approximate, numeric value with a binary precision 53 (zero or absolute value 10[–308] to 10[308]) (SQL_DOUBLE). This maps to Double. |
| Image | Variable length binary data. Maximum length is data source–dependent (SQL_LONGVARBINARY). This maps to an Array of type Byte. |
| Int | Exact numeric value with precision 10 and scale 0 (signed: –2[31] <= n <= 2[31] – 1, unsigned:0 <= n <= 2[32] – 1) (SQL_INTEGER). This maps to Int32. |
| NChar | Unicode character string of fixed string length (SQL_WCHAR). This maps to String. |
| NText | Unicode variable-length character data. Maximum length is data source–dependent. (SQL_WLONGVARCHAR). This maps to String. |
| Numeric | Signed, exact, numeric value with a precision p and scale s, where 1 <= p <= 15, and s <= p (SQL_NUMERIC). This maps to Decimal. |
| NVarChar | A variable-length stream of Unicode characters (SQL_WVARCHAR). This maps to String. |
| Real | Signed, approximate, numeric value with a binary precision 24 (zero or absolute value 10[–38] to 10[38]).(SQL_REAL). This maps to Single. |
| SmallDateTime | Data and time data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to DateTime. |
| SmallInt | Exact numeric value with precision 5 and scale 0 (signed: –32,768 <= n <= 32,767, unsigned: 0 <= n <= 65,535) (SQL_SMALLINT). This maps to Int16. |
| Text | Variable length character data. Maximum length is data source–dependent (SQL_LONGVARCHAR). This maps to String. |
| Time | Date data in the format hhmmss (SQL_TYPE_TIMES). This maps to DateTime. |
| Timestamp | A stream of binary data (SQL_BINARY). This maps to an Array of type Byte. |
| TinyInt | Exact numeric value with precision 3 and scale 0 (signed: –128 <= n <= 127, unsigned:0 <= n <= 255)(SQL_TINYINT). This maps to Byte. |
| UniqueIdentifier | A fixed-length, globally unique identifier (GUID) (SQL_GUID). This maps to Guid. |
| VarBinary | Variable length binary. The maximum is set by the user (SQL_VARBINARY). This maps to an Array of type Byte. |
| VarChar | A variable-length stream character string (SQL_CHAR). This maps to String. |
Requirements
Namespace: System.Data.Odbc
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
Assembly: System.Data (in System.Data.dll)
See Also
Show: