Difference Between Sql Server VARCHAR and NVARCHAR Data Type

 Posted by Niladri.Biswas on 5/15/2013 | Category: Sql Server Interview questions | Views: 1365 | Points: 40
Answer:

1)Varchar takes 1 byte per character.NVarchar takes 2 bytes per Unicode/Non-Unicode character.

2)Varchar can store maximum 8000 Non-Unicode characters.NVarchar can store maximum 4000 Unicode/Non-Unicode characters.

3)Varchar takes no. of bytes equal to the no. of Characters entered plus two bytes extra for defining offset.NVarchar takes no. of bytes equal to twice the no. of Characters entered plus two bytes extra for defining offset.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response