SQL Server char nchar nvarchar varchar

Char stores a fixed-length string with a maximum length of 8,000 bytes.

varchar stores a variable-length string with a maximum length of 8,000 bytes.

NCHAR stores a fixed-length Unicode string with a maximum length of 4,000 characters.

Nvarchar stores a variable-sung Unicode string with a maximum length of 4000 value characters.

Note that the following are:

The allocation of storage space will be different, such as varchar (10) allocated 10 bytes nvarchar (10) can be allocated 20 bytes. That is to say nvarchar (10) or varchar (10) stores more information. Because one is a byte store, one is a character.

SQL Server char nchar nvarchar varchar