What is the difference between char, nchar, varchar, and nvarchar in MSSQL?
-
nchar and nvarchar can store Unicode characters.
-
char and varchar cannot store Unicode characters.
-
char and nchar 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 and nvarchar are variable-length which will only use up spaces for the characters you store. It will not reserve storage like char or nchar.
-
char: fixed-length character data with a maximum length of 8000 characters.
-
nchar: fixed-length unicode data with a maximum length of 4000 characters.
-
Char = 8 bit length
-
NChar = 16 bit length
http://
http://stackoverflow.com/questions/176514/what-is-the-difference-between-char-nchar-varchar-and-nvarchar-in-mssql
Contributed by:
Rohit kakria
I am software developer
Resourse address on xpode.com
http://www.xpode.com/Print.aspx?Articleid=586
Click here to go on website
|