Stimulsoft.Base.StiDbType.Odbc Enumeration

Syntax

C++

Visual Basic

public: enum Odbc { BigInt = 1, Binary = 2, Bit = 3, Char = 4, DateTime = 5, Decimal = 6, Numeric = 7, Double = 8, Image = 9, Int = 10, NChar = 11, NText = 12, NVarChar = 13, Real = 14, UniqueIdentifier = 15, SmallDateTime = 16, SmallInt = 17, Text = 18, Timestamp = 19, TinyInt = 20, VarBinary = 21, VarChar = 22, Date = 23, Time = 24 };

Members

Members	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 System.Int64.
Binary	A stream of binary data (SQL_BINARY). This maps to an System.Array of type System.Byte.
Bit	Single bit binary data (SQL_BIT). This maps to System.Boolean.
Char	A fixed-length character string (SQL_CHAR). This maps to System.String.
DateTime	Date data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to System.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 System.Decimal.
Numeric	Signed, exact, numeric value with a precision p and scale s, where 1 <= p <= 15, and s <= p (SQL_NUMERIC). This maps to System.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 System.Double.
Image	Variable length binary data. Maximum length is data source–dependent (SQL_LONGVARBINARY). This maps to an System.Array of type System.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 System.Int32.
NChar	Unicode character string of fixed string length (SQL_WCHAR). This maps to System.String.
NText	Unicode variable-length character data. Maximum length is data source–dependent. (SQL_WLONGVARCHAR). This maps to System.String.
NVarChar	A variable-length stream of Unicode characters (SQL_WVARCHAR). This maps to System.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 System.Single.
UniqueIdentifier	A fixed-length GUID (SQL_GUID). This maps to System.Guid.
SmallDateTime	Data and time data in the format yyyymmddhhmmss (SQL_TYPE_TIMESTAMP). This maps to System.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 System.Int16.
Text	Variable length character data. Maximum length is data source–dependent (SQL_LONGVARCHAR). This maps to System.String.
Timestamp	A stream of binary data (SQL_BINARY). This maps to an System.Array of type System.Byte.
TinyInt	Exact numeric value with precision 3 and scale 0 (signed: –128 <= n <= 127, unsigned:0 <= n <= 255)(SQL_TINYINT). This maps to System.Byte.
VarBinary	Variable length binary. The maximum is set by the user (SQL_VARBINARY). This maps to an System.Array of type System.Byte.
VarChar	A variable-length stream character string (SQL_CHAR). This maps to System.String.
Date	Date data in the format yyyymmdd (SQL_TYPE_DATE). This maps to System.DateTime.
Time	Date data in the format hhmmss (SQL_TYPE_TIMES). This maps to System.DateTime.

Remarks

This is record Stimulsoft.Base.StiDbType.Odbc.

File

StiDbType.cs

Made with Doc-O-Matic.

What do you think about this topic? Send feedback!