What is the difference between char , varchar and nvarchar?
2878
29-Dec-2013
Sumit Kesarwani
29-Dec-2013char(n)Fixed length non unicode character data with length of n bytes.n must be a value from 1 through 8,000.
varchar(n)variable length non unicode character data with length of n bytes.
nvarchar(n)variable length unicode character data of n characters. n must be a value from 1 through 4,000.