OdbcType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the data type of a field, property, for use in an OdbcParameter.
public enum class OdbcType
public enum OdbcType
type OdbcType =
Public Enum OdbcType
- Inheritance
Fields
BigInt | 1 | 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 | 2 | A stream of binary data (SQL_BINARY). This maps to an Array of type Byte. |
Bit | 3 | Single bit binary data (SQL_BIT). This maps to Boolean. |
Char | 4 | A fixed-length character string (SQL_CHAR). This maps to String. |
Date | 23 | Date data in the format yyyymmdd (SQL_TYPE_DATE). This maps to DateTime. |
DateTime | 5 | Date data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to DateTime. |
Decimal | 6 | 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 | 8 | 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 | 9 | Variable length binary data. Maximum length is data source-dependent (SQL_LONGVARBINARY). This maps to an Array of type Byte. |
Int | 10 | 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 | 11 | Unicode character string of fixed string length (SQL_WCHAR). This maps to String. |
NText | 12 | Unicode variable-length character data. Maximum length is data source-dependent. (SQL_WLONGVARCHAR). This maps to String. |
Numeric | 7 | 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 | 13 | A variable-length stream of Unicode characters (SQL_WVARCHAR). This maps to String. |
Real | 14 | 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 | 16 | Data and time data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to DateTime. |
SmallInt | 17 | 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 | 18 | Variable length character data. Maximum length is data source-dependent (SQL_LONGVARCHAR). This maps to String. |
Time | 24 | Date data in the format hhmmss (SQL_TYPE_TIMES). This maps to DateTime. |
Timestamp | 19 | A stream of binary data (SQL_BINARY). This maps to an Array of type Byte. |
TinyInt | 20 | Exact numeric value with precision 3 and scale 0 (signed: -128 <= n <= 127, unsigned:0 <= n <= 255)(SQL_TINYINT). This maps to Byte. |
UniqueIdentifier | 15 | A fixed-length GUID (SQL_GUID). This maps to Guid. |
VarBinary | 21 | Variable length binary. The maximum is set by the user (SQL_VARBINARY). This maps to an Array of type Byte. |
VarChar | 22 | A variable-length stream character string (SQL_CHAR). This maps to String. |
Remarks
The following table shows mappings between OdbcType data types, ODBC data types (shown in parentheses), and .NET Framework types.
Applies to
.NET
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기