SQL data types

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
1.0x10-28 to 7.9x1028.

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).