What is the difference between char , varchar and nvarchar?
244929-Dec-2013
interview
Home / DeveloperSection / Interviews / What is the difference between char , varchar and nvarchar?
Home / DeveloperSection / Interviews / What is the difference between char , varchar and nvarchar?
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.