Home / Uncategorized / What is the difference between varchar and nvarchar in SQL Server?

What is the difference between varchar and nvarchar in SQL Server?

Nvarchar stores UNICODE data. If you have requirements to store UNICODE or multilingual data, nvarchar is the choice.

Varchar stores ASCII data and should be your data type of choice for normal use.

Regarding memory usage, nvarchar uses 2 bytes per character, whereas varchar uses 1.

About Mohammad Fareed

Software Engineer @ Tekzenit.

Check Also

Scientist Finds Breakthrough Weight Loss Formula!

Don’t act so surprised, Your Highness. You weren’t on any mercy mission this time. Several …

Leave a Reply

Your email address will not be published. Required fields are marked *