CHAR vs VARCHAR

CHAR:

1. It is a fixed length data type
2. Used to store non-Unicode characters
3. Occupiers 1 byte of space for each character

VARCHAR:

1. It is a variable length data type
2. Used to store non-Unicode characters
3. Occupies 1 byte of space for each character

NCHAR vs NVARCHAR

NCHAR

1. Is a fixed length data type
2. Used to store Unicode characters (for example the languages Arabic, German and so on)
3. Occupies 2 bytes of space for each character

NVARCHAR

1. It is a variable-length data type
2. Used to store Unicode characters
3. Occupies 2 bytes of space for each character