Just to clear up… or sum up…
nchar
andnvarchar
can store Unicode characters.char
andvarchar
cannot store Unicode characters.char
andnchar
are fixed-length which will reserve storage space for number of characters you specify even if you don’t use up all that space.varchar
andnvarchar
are variable-length which will only use up spaces for the characters you store. It will not reserve storage likechar
ornchar
.
nchar
and nvarchar
will take up twice as much storage space, so it may be wise to use them only if you need Unicode support.