SQL Server Data Types
SQL Server data types, with descriptions, size limits, and storage requirements.
Download optionsThe records
10 of 35 records ยท Select a column heading to sort.
| ID | Data type | Description | Max size | Storage |
|---|---|---|---|---|
| 1 | char(n) | Fixed width character string | 8,000 characters | Defined width |
| 2 | varchar(n) | Variable width character string | 8,000 characters | 2 bytes + number of chars |
| 3 | varchar(max) | Variable width character string | 1,073,741,824 characters | 2 bytes + number of chars |
| 4 | text | Variable width character string | 2GB of text data | 4 bytes + number of chars |
| 5 | nchar | Fixed width Unicode string | 4,000 characters | Defined width x 2 |
| 6 | nvarchar | Variable width Unicode string | 4,000 characters | |
| 7 | nvarchar(max) | Variable width Unicode string | 536,870,912 characters | |
| 8 | ntext | Variable width Unicode string | 2GB of text data | |
| 9 | binary(n) | Fixed width binary string | 8,000 bytes | |
| 10 | varbinary | Variable width binary string | 8,000 bytes |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
No source links are listed for this dataset. Ask about its coverage before using it where accuracy or recency matters.
A complete download includes all 35 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/sqlserverdatatypesChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.