Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

OdbcType Enumeration

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

Namespace: System.Data.Odbc
Assembly: System.Data (in system.data.dll)

public enum OdbcType
public enum OdbcType
public enum OdbcType
 Member nameDescription
BigIntExact 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
BinaryA stream of binary data (SQL_BINARY). This maps to an Array of type Byte
BitSingle bit binary data (SQL_BIT). This maps to Boolean
CharA fixed-length character string (SQL_CHAR). This maps to String
DateDate data in the format yyyymmdd (SQL_TYPE_DATE). This maps to DateTime
DateTimeDate data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to DateTime
DecimalSigned, 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
DoubleSigned, approximate, numeric value with a binary precision 53 (zero or absolute value 10[–308] to 10[308]) (SQL_DOUBLE). This maps to Double
ImageVariable length binary data. Maximum length is data source–dependent (SQL_LONGVARBINARY). This maps to an Array of type Byte
IntExact 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
NCharUnicode character string of fixed string length (SQL_WCHAR). This maps to String
NTextUnicode variable-length character data. Maximum length is data source–dependent. (SQL_WLONGVARCHAR). This maps to String
NumericSigned, exact, numeric value with a precision p and scale s, where 1 <= p <= 15, and s <= p (SQL_NUMERIC). This maps to Decimal
NVarCharA variable-length stream of Unicode characters (SQL_WVARCHAR). This maps to String
RealSigned, approximate, numeric value with a binary precision 24 (zero or absolute value 10[–38] to 10[38]).(SQL_REAL). This maps to Single
SmallDateTimeData and time data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to DateTime
SmallIntExact 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
TextVariable length character data. Maximum length is data source–dependent (SQL_LONGVARCHAR). This maps to String
TimeDate data in the format hhmmss (SQL_TYPE_TIMES). This maps to DateTime
TimestampA stream of binary data (SQL_BINARY). This maps to an Array of type Byte
TinyIntExact numeric value with precision 3 and scale 0 (signed: –128 <= n <= 127, unsigned:0 <= n <= 255)(SQL_TINYINT). This maps to Byte
UniqueIdentifierA fixed-length GUID (SQL_GUID). This maps to Guid
VarBinaryVariable length binary. The maximum is set by the user (SQL_VARBINARY). This maps to an Array of type Byte
VarCharA variable-length stream character string (SQL_CHAR). This maps to String

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

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.