SQL Server - What is the difference between Varchar and NVarchar

By [)ia6l0 iii

Varchar can store non-Unicode character data where as nvarchar can store Unicode character data.

In other words, if you expect your data to be multilingual , then you should use the Nvarchar type of fields. These fields can store characters that are a mixture of English and non-english symbols.

Related FAQs

11g provides the following new features over 10g
This is extremely useful function when you want to display number of characters depending on some column value.
Normalization in databases refers to representing data in a manner with least representation so that its accessible in all the ways.
The error means that you attempted to truncate a table with unique/primary key that is referenced as foriegn key in another table.
You can now do the inline variable assignment in SQL Server 2008.
User Defined functions can be used inside a Select clause or a conditional statement such as Case. It can also be used in filtering statements such as Where. User Defined functions need to return a value, where as Stored procedures may not return. Stored are pre-compiled unlike the functions that are compiled at runtime.
SQL Server - What is the difference between Varchar and NVarchar  (1351 Views)