Difference between VARCHAR and NVARCHAR

Answer:

VARCHAR:

1.Storage: 8 bit
2.Abbreviation: Variable -Length Character String
3.Accepts only English character
4.Doesn't supports other language symbols
5.Runs faster than NVARCHAR as consumes less memory
6.Use this when you develop the application for only local purpose

NVARCHAR:

1.Storage: 16 bit
2.Abbreviation: uNicode
3.Accepts both English character and non-English symbols
4.supports other language symbols
5.Runs slower than VARCHAR as consumes less memory
6.Use this when you use your application globally