What is the Difference Between VARCHAR and NVARCHAR in SQL Server ?
In principle, they are the same and are handled in the same way by your application. The only difference is that NVARCHAR can handle Unicode characters, allowing you to use multiple languages in the database (Arabian, Chinese etc.). NVARCHAR takes twice as much space when compared to VARCHAR. Use NVARCHAR only if you need localization or internationalization support.