nvarchar or varchar
which is the best varchar or nvarchar, and what is the benefits of each?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pradeep ShetPosted Jan 18, 2015, 7:40 AM
Find the link below for difference between the char, varchar, nchar, nvarchar
I have written small article for it
http://www.c-sharpcorner.com/UploadFile/cda5ba/difference-between-char-nchar-varchar-and-nvarchar-data-ty/
Murugesh PPosted Jan 16, 2015, 6:58 AM
http://stackoverflow.com/questions/144283/what-is-the-difference-between-varchar-and-nvarchar
VulpesPosted Jan 16, 2015, 6:54 AM
The difference between them is that nvarchar stores unicode data (2 bytes per character) and varchar stores non-unicode data, typically ANSI (1 byte per character) though other single byte code pages can be used as well.
So, if you don't need characters outside the ANSI range (0 to 255), then using varchar will save memory.
However, there is a view nowadays that, with memory and disk storage being cheap, you should always use unicode character types despite the memory hit.
This view is evidently espoused by the .NET designers as the string type always uses unicode.