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
|
|
|
Helpful Website Url
|
http://stackoverflow.com/questions/176514/what-is-the-difference-between-char-nchar-varchar-and-nvarchar-in-mssql
|
Share this article
| Print |
Article read by 3629 times
|
|
|