| Both varchar or nvarchar are sql server data types and both of these are store the string values.Below are the some difference between them:-
(1)Abbreviation
The abbreviation for Varchar is Variable Length character String.
The abbreviation of NVarchar is uNicode Variable Length character String.
(2)Types of data
The Varchar allocates single byte for a character. So can be used to store for 8000 characters in this datatype.
The NVarchar allocates two bytes for a character. Because this Nvarchar type allows to store the special characters. So can be used to store for 4000 characters in this types.
(3)Extended DataType
To store more length of uNicode string, the you have to go for the TEXT and NTEXT data types.
(4)Maximum Length
Varchar - 8,000 bytes
NVarchar - 4,000 bytes
(5)Character Data Type
Varchar - Non-Unicode Data
NVarchar - Unicode Data
(6)Character Size
Varchar - 1 byte
NVarchar - 2 bytes
(7)Storage Size
Varchar - Actual Length (in bytes)
NVarchar - 2 times Actual Length (in bytes) | | |