Notation | Type | Range | ||
character(1) ‑ character(n) | character | n represents the lesser of the maximum configured row size and 32,000. | ||
varchar(1) ‑ varchar(n) | character | n represents the lesser of the maximum configured row size and 32,000. | ||
long varchar | character | A string of 1 to 2 GB characters | ||
nchar | Unicode | A string of 1 to maximum configured row size, but not exceeding 16,000 characters (32,000 bytes). | ||
nvarchar | Unicode | A string of 1 to maximum configured row size, but not exceeding 16,000 characters (32,000 bytes). | ||
long nvarchar | Unicode | A string of 1 to a maximum of 1 GB Unicode characters (that is, 2 bytes to a maximum of 2 GB in length). | ||
tinyint | 1-byte integer | -128 to +127 | ||
smallint | 2‑byte integer | ‑32,768 to +32,767 | ||
integer | 4‑byte integer | ‑2,147,483,648 to +2,147,483,647 | ||
bigint | 8-byte integer | -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807 | ||
decimal(p, s) | fixed‑point exact numeric | Depends on precision and scale; default is (5,0): ‑99999 to +99999. Maximum number of digits is 39. | ||
real | 4‑byte floating | ‑1.0e+38 to +1.0e+38 (7 digit precision) | ||
float | 8‑byte floating | ‑1.0e+38 to +1.0e+38 (16 digit precision) | ||
date | date (12 bytes) | 1‑jan‑0001 to 30‑dec‑9999 | ||
money | money (8 bytes) | $-999,999,999,999.99 to $999,999,999,999.99 | ||
long byte | binary | 1 to 2 GB of binary data | ||