SqlDbType Enumeration
Specifies SQL Server-specific data type of a field, property, for use in a SqlParameter.
[Visual Basic] <Serializable> Public Enum SqlDbType [C#] [Serializable] public enum SqlDbType [C++] [Serializable] __value public enum SqlDbType [JScript] public Serializable enum SqlDbType
Members
| Member name | Description |
|---|---|
| BigInt Supported by the .NET Compact Framework. | Int64 A 64-bit signed integer. |
| Binary Supported by the .NET Compact Framework. | Array of type Byte A fixed-length stream of binary data ranging between 1 and 8,000 bytes. |
| Bit Supported by the .NET Compact Framework. | Boolean An unsigned numeric value that can be 0, 1, or a null reference (Nothing in Visual Basic). |
| Char Supported by the .NET Compact Framework. | String A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| DateTime Supported by the .NET Compact Framework. | DateTime Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds. |
| Decimal Supported by the .NET Compact Framework. | Decimal A fixed precision and scale numeric value between -1038 -1 and 10 38 -1. |
| Float Supported by the .NET Compact Framework. | Double A floating point number within the range of -1.79E +308 through 1.79E +308. |
| Image Supported by the .NET Compact Framework. | Array of type Byte A variable-length stream of binary data ranging from 0 to 231 -1 (or 2,147,483,647) bytes. |
| Int Supported by the .NET Compact Framework. | Int32 A 32-bit signed integer. |
| Money Supported by the .NET Compact Framework. | Decimal A currency value ranging from -263 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a currency unit. |
| NChar Supported by the .NET Compact Framework. | String A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters. |
| NText Supported by the .NET Compact Framework. | String A variable-length stream of Unicode data with a maximum length of 230 - 1 (or 1,073,741,823) characters. |
| NVarChar Supported by the .NET Compact Framework. | String A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Note Implicit conversion fails if the string is greater than 4,000 characters. Explicitly set the object when working with strings longer than 4,000 characters. |
| Real Supported by the .NET Compact Framework. | Single A floating point number within the range of -3.40E +38 through 3.40E +38. |
| SmallDateTime Supported by the .NET Compact Framework. | DateTime Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute. |
| SmallInt Supported by the .NET Compact Framework. | Int16 A 16-bit signed integer. |
| SmallMoney Supported by the .NET Compact Framework. | Decimal A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit. |
| Text Supported by the .NET Compact Framework. | String A variable-length stream of non-Unicode data with a maximum length of 231 -1 (or 2,147,483,647) characters. |
| Timestamp Supported by the .NET Compact Framework. | Array of type Byte Automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes. |
| TinyInt Supported by the .NET Compact Framework. | Byte An 8-bit unsigned integer. |
| UniqueIdentifier Supported by the .NET Compact Framework. | Guid A globally unique identifier (or GUID). |
| VarBinary Supported by the .NET Compact Framework. | Array of type Byte A variable-length stream of binary data ranging between 1 and 8,000 bytes. Note Implicit conversion fails if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes. |
| VarChar Supported by the .NET Compact Framework. | String A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
| Variant Supported by the .NET Compact Framework. | Object A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared. |
Requirements
Namespace: System.Data
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, .NET Compact Framework
Assembly: System.Data (in System.Data.dll)