Varchar vs. NVarchar

SQL Server provides both data types to store character information. Basically the two data types are identical in how you would work with them in your database or in your application.

The main difference is that nvarchar is used to store unicode data, which is used to store multilingual data in your database tables. Other languages have an extended set of character codes that need to be saved and this data type allows for this extension.

If you will not be working with multilingual data you should use the varchar datatype instead. The main reason for this is that nvarchar uses twice as much space as varchar, again because of the need to store the extended character codes for other languages

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s