Your question is not very clear.
There are only three types of string types -
char
,
text
and
varchar
.
Both text and varchar support date lengths upto 2GB.
Nvarchar
and
ntext
are used only for storing unicode characters.
As per
documentation[
^], text and ntext will be removed in a future release.
There is another type called
sql_variant
that can store values of various data types.