System.Data.Odbc.OdbcType Enumeration

Specifies the data type of a field, property, for use in an System.Data.Odbc.OdbcParameter.

Syntax

public enum OdbcType

Remarks

The following table shows mappings between System.Data.Odbc.OdbcType data types, ODBC data types (shown in parentheses), and .NET Framework types.

Members

Member NameDescription
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 long.

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

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

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

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

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 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
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 1.0.5000.0, 2.0.0.0