public enum VistaDBType : System.Enum
'Declaration
Public Enum VistaDBType Inherits System.Enum
'Usage
Dim instance As VistaDBType
Member | Description |
---|---|
BigInt | System.Int64.
64-bit signed integer. Corresponding to SqlDbType.BigInt |
Binary | System.Byte[].
Fixed length binary data with a maximum length of 8000 bytes. Storage is inside the record Corresponding to SqlDbType.Binary |
Bit | System.Boolean.
Boolean value that can be true, false, or null. Corresponding to SqlDbType.Bit |
Char | System.String. Char(x)
Fixed length character data with length of N characters. N must be a value from 1 through 8192. Storage size is N bytes of the data converted from Unicode string to non-Unicode character array. |
Date | System.DateTime.
A date only. From Jan 1, 0001 to Dec 31, 9999. Stored internally as a DateTime at midnight. |
DateTime | System.DateTime.
Same as the SQL Server type DateTime2 (a .NET DateTime). Internal storage of this data type is 8 bytes. Date and time data ranging and accuracy are respective System.DateTime ranging and accuracy Corresponding to SqlDbType.DateTime2 |
DateTime2 | System.DateTime.
Internal storage of this data type is 8 bytes. Date and time data ranging and accuracy are respective System.DateTime ranging and accuracy Corresponding to SqlDbType.DateTime2 |
DateTimeOffset | System.DateTimeOffset.
A DateTime and specific timezone offset. |
Decimal | System.Decimal 128-bit (16-byte) integer scaled by a variable power of 10. Enumeration VistaDBType System.Data.SqlDbType.Decimal |
Float | System.Double A double-precision (64-bit) floating-point number within the range of -1.79E +308 through 1.79E +308. Corresponding to SqlDbType.Float |
Image | System.Byte[].
Variable length binary data with a maximum length of 134213632 bytes multiplied by database page size expressed in kilobytes (1 through 16). Actual data is outside the record (extended row data). Corresponding to SqlDbType.Image |
Int | System.Int32.
32-bit signed integer. Corresponding to SqlDbType.Int |
Money | System.Decimal.
Signed 64-bit (8-byte) integers with scaling factor '4'. Store 8 bytes Relies on .Net Decimal type with fixed scaling factor Corresponding to SqlDbType.Money |
NChar | System.String. NChar(x)
Fixed length Unicode character data of N characters. N must be a value from 1 through 8192. Storage size is two times N bytes Corresponding to SqlDbType.NChar |
NText | System.String.
Variable length Unicode character data with no explicit length. Storage is outside the record (extended type). Storage data is Unicode character array. Maximum length is 67106816 characters multiplied by database file page size expressed in kilobytes (1 through 16). Corresponding to SqlDbType.NText |
NVarChar | System.String. NVarchar(x)
Variable length character data with length of N characters. N must be a value from 1 through 8192. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length. NVarchar data are stored inside the record. Corresponding to SqlDbType.NVarChar |
Real | System.Single.
A floating point number within the range of -3.40E +38 through 3.40E +38. Corresponding to SqlDbType.Real |
SmallDateTime | System.DateTime.
Date and time data ranging in value from January 1, 1900 0:00 to November 30, 4451 1:19 PM an accuracy of one minute. Internal storage of this data type is 4 bytes Corresponding to SqlDbType.SmallDateTime |
SmallInt | System.Int16.
16-bit signed integer. Corresponding to SqlDbType.SmallInt |
SmallMoney | System.Decimal.
Signed 32-bit (4-byte) integers with scaling factor '4'. Store 4 bytes. Same as Currency but with less dynamic borders from -214,748.3648 through +214,748.3647 Corresponding to SqlDbType.SmallMoney |
Text | System.String.
Variable length character data with no explicit length. Storage is outside the record (extended type). Storage data is non-Unicode character array. Maximum length is 134213632 characters multiplied by database file page size expressed in kilobytes (1 throw 16). Corresponding to SqlDbType.Text |
Time | System.Timespan.
Time of day with a precision of 100 nanoseconds. Stored internally as a timespan since midnight. |
Timestamp | System.Int64.
64-bit signed integer. Automatically generated binary numbers, which are guaranteed to be unique within a database. This datatype does not store date or time information.Corresponding to SqlDbType.TimeStamp This is from the SQL Server docs: Is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes. The timestamp data type is just an incrementing number and does not preserve a date or a time. To record a date or time, use a DateTime data type. We use a 64 bit integer which is functionally the same as an 8 byte binary value. 8 binary bytes (8 bits each) is a 64 bit value. We visually show it to the user differently in the Data Builder than how Microsoft does. The SQL Server management studio shows the TIMESTAMP as BINARY data, we show the actual value. We use a single 64 bit value to make comparisons faster, rather than comparing each 8 bit value across 8 bytes. |
TinyInt | System.Byte.
8-bit unsigned integer. Corresponding to SqlDbType.TinyInt |
Uninitialized | Uninitialized is used internally to indicate when a VistaDBType has not yet been set to anything. |
UniqueIdentifier | System.Guid.
A globally unique identifier (or GUID). Storage is inside the record Corresponding to SqlDbType.UniqueIdentifier |
Unknown | Reserved |
VarBinary | System.Byte[].
Varying length binary data with a maximum length of 800 bytes. Storage is inside the record Corresponding to SqlDbType.VarBinary |
VarChar | System.String. Varchar(x)
Variable length character data with length of N characters. N must be a value from 1 through 8192. Storage size is the actual length in bytes of the data entered and converted from Unicode string to non-Unicode character array, not a fixed size. The data entered can be 0 characters in length. Varchar data are stored inside the record. Corresponding to SqlDbType.VarChar |
System.Object
System.ValueType
System.Enum
VistaDB.VistaDBType
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2