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.



You May Interest

MS SQL Getting List of All Column Names of a Table

What is Auditing Inside SQL Server ?

What is an Index in SQL Server ?

Using CASE WHEN in MS SQL

What is Log Shipping in SQL Server ?