What is the difference between char , varchar and nvarchar?
Ask by Sumit Kesarwani
Updated 16 Sep 2020
char(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.