The following are SQL data types used.
Data Type | Description |
---|---|
Boolean |
A simple value of true or false. A Boolean value expresses the validity of a condition. |
Byte |
An 8-bit unsigned integer ranging in value from 0 to 255. The Byte data type is used for containing binary data. |
Char |
Variables stored as unsigned 16-bit (2-byte) numbers ranging in value from 0 through 65535. Each number represents a single Unicode character. |
Decimal |
A simple type
representing values ranging from |
Double |
A floating point type representing values ranging from approximately 5.0x10-324 to 1.7x10-308 with a precision of 15-16 digits. |
Int |
An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647. |
Int16 |
An integral type representing signed 16-bit integers with values between -32768 and 32767. |
Int32 |
An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647. |
Int64 |
An integral type representing signed 64-bit integers with values between -9223372036854775808 and -9223372036854775807. |
IntPtr |
A signed integer whose size depends on the underlying platform (a 32-bit value on a 32-bit platform and a 64-bit value on a 64-bit platform). |
SByte |
An integral type representing singed 8-bit integers with values between -128 and 127. |
Single |
A floating point type representing values ranging from approximately 1.5x10-45 to 3.4x1038 with a precision of 7 digits. |
String |
A type representing Unicode character strings. |
UInt16 |
An integral type representing unsigned 16-bit integers with values between 0 and 65535. |
UInt32 |
An integral type representing unsigned 32-bit integers with values between 0 and 4294967295. |
UInt 64 |
An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615. |
UIntPtr |
An unsigned integer whose size depends on the underlying platform (a 32- bit value on a 32-bit platform and a 64-bit value on a 64-bit platform). |