See Reference Manual: Building Blocks for more information about datatypes.
Datatypes by category |
Synonyms |
Range |
Bytes of storage |
|---|---|---|---|
Exact numeric: integers |
|||
bigint |
Whole numbers between 263 and -263 - 1 (from -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807, inclusive |
8 |
|
int |
integer |
231 -1 (2,147,483,647) to -231 (-2,147,483,648 |
4 |
smallint |
|
215 -1 (32,767) to -215 (-32,768) |
2 |
tinyint |
|
0 to 255 (Negative numbers are not permitted) |
1 |
unsigned bigint |
Whole numbers between 0 and 18,446,744,073,709,551,615 |
8 |
|
unsigned int |
Whole numbers between 0 and 4,294,967,295 |
4 |
|
unsigned smallint |
Whole numbers between 0 and 65535 |
2 |
|
Exact numeric: decimals |
|||
numeric (p, s) |
|
1038 -1 to -1038 |
2 to 17 |
decimal (p, s) |
dec |
1038 -1 to -1038 |
2 to 17 |
Approximate numeric |
|||
float (precision) |
|
machine dependent |
4 for default precision < 16, 8 for default precision >= 16 |
double precision |
|
machine dependent |
8 |
real |
|
machine dependent |
4 |
Money |
|||
smallmoney |
|
214,748.3647 to -214,748.3648 |
4 |
money |
922,337,203,685,477.5807 to -922,337,203,685,477.5808 |
8 |
|
Date/time |
|||
smalldatetime |
|
January 1, 1900 to June 6, 2079 |
4 |
datetime |
|
January 1, 1753 to December 31, 9999 |
8 |
date |
|
January 1, 0001 to December 31, 9999 |
4 |
time |
12:00:00AM to 11:59:59:999PM |
4 |
|
bigdatetime |
January 1, 0001 to December 31, 9999 and 12:00.000000AM to 11:59:59.999999 PM |
8 |
|
bigtime |
12:00:00.000000 AM to 11:59:59.999999 PM |
8 |
|
Character |
|||
char(n) |
character |
pagesize |
n |
varchar(n) |
character varying, char varying |
pagesize |
actual entry length |
unichar |
Unicode character |
pagesize |
n * @@unicharsize (@@unicharsize equals 2) |
univarchar |
Unicode character varying, char varying |
pagesize |
actual number of characters * @@unicharsize |
nchar(n) |
national character, national char |
pagesize |
n * @@ncharsize |
nvarchar(n) |
nchar varying, national char varying, national character varying |
pagesize |
@@ncharsize * number of characters |
text |
|
231 -1 (2,147,483,647) bytes or fewer |
0 when uninitialized; multiple of 2K after initialization |
unitext |
1 – 1,073,741,823 |
0 when uninitialized; multiple of 2K after initialization |
|
Binary |
|||
binary(n) |
|
pagesize |
n |
varbinary(n) |
|
pagesize |
actual entry length |
image |
231 -1 (2,147,483,647) bytes or fewer |
0 when uninitialized; multiple of 2K after initialization |
|
Bit |
|||
bit |
|
0 or 1 |
1 (one byte holds up to 8 bit columns) |
