Enum CmdParamsDbType
Specifies the type of command parameters.
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
public enum CmdParamsDbType
Fields
Name | Description |
---|---|
AnsiString | An extension of the ASCII character set in that it includes all the ASCII characters with an additional 128 character codes |
AnsiStringFixedLength | fixed-length stream of non-Unicode characters. |
Binary | System.Array of type System.Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes. |
Boolean | 2 logical values, true and false |
Byte | Allows whole numbers from 0 to 255 |
Currency | Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which country's currency to use |
Date | Date data ranging in value from January 1,1 AD through December 31, 9999 AD. |
DateTime | System.DateTime. Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. |
DateTime2 | From January 1, 0001 to December 31, 9999 with an accuracy of 100 nanoseconds |
DateTimeOffset | Date and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00. |
Decimal | System.Decimal. A fixed precision and scale numeric value between -10 to -1 and 10 to -1. |
Double | Double precision floating-point. Will handle most decimals. |
Guid | Stores a globally unique identifier. |
Int16 | A 16-bit signed integer. |
Int32 | A 32-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647 |
Int64 | A 64-bit signed integer. Allows whole numbers from -2,147,483,648 to 2,147,483,647 |
Object | Can store pictures, audio, video, or other BLOBs (Binary Large OBjects) |
SByte | Signed integer |
Single | Single precision floating-point. Will handle most decimals Allows whole numbers from -128 to 127 |
String | Used for string datatypes |
StringFixedLength | A fixed-length string of Unicode characters. |
Time | Time data based on a 24-hour clock. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. |
UInt16 | A 32-bit un-signed integer. Allows whole numbers from 0 to 65535 |
UInt32 | A 32-bit un-signed integer. Allows whole numbers from 0 to 4294967295 |
UInt64 | A 64-bit un-signed integer. Allows whole numbers from 0 to 18446744073709551615 |
VarNumeric | A variable-length numeric value. |
Xml | A SQL Server 2005 user-defined type (UDT). Stores XML formatted data. Maximum 2GB |