SQL Tutorial: Character Strings Data Types

Data Type Description
char

Maximum length of 8,000 characters.

varchar

Maximum of 8,000 characters.

varchar(max)

max indicates that the maximum storage size is 2^31-1 bytes (2 GB)

text

Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters.

Unicode Data Types

Data Type Description
nchar

Maximum length of 4,000 characters.

nvarchar

Maximum length of 4,000 characters

nvarchar(max)

max indicates that the maximum storage size is 2^31-1 bytes (2 GB)

ntext

Maximum length of 1,073,741,823 characters.