vote buttons
1
1
beginner
0
intermediate
0
advanced
10-Nov-2014 12:26 UTC
Super Human
1164

2 Answers

vote buttons
1

varchar and nvarchar both are variable length storage columns (i.e. they only take up as much space as required as against char & nchar which take up fixed amount of space irrespective of data length).

The difference between varchar & nvarchar is nvarchar can store any Unicode data thus supporting text in all languages while a varchar column is limited to 8-bit code pages and cannot support text in languages which require unicode data.

So nvarchar can end up taking up double the space than that required for varchar.

However also note as most modern systems now use Unicode, using varchar may internally require conversion which could be expensive.


10-Nov-2014 12:27 UTC
Super Human
1164
vote buttons
-1

VARCHAR is an abbreviation for variable-length character string. It is a string of text characters.The maximum size of a VARCHAR is 8,000 bytes and Varchar stores ascii data.ASCII only requires 1 byte for each character.Single row of
a single varchar column can be varchar(8000),

Nvarchar stores UNICODE data.NVARCHAR is identical to VARCHAR but it supports two-byte characters. But a single row of a single nvarchar column can only be nvarchar (4000).If you want more information about the varchar and the nvarchar from the research paper resources.

12-Feb-2015 06:42 UTC
cathytreat
-2