What is the difference between varchar and nvarchar types?
Answer Posted / anindya basu
The differences are as under:
a. While Varchar is an ASCII data type, nVarchar is a Unicode data type.
b. While Varchar takes 1 byte per character, Unicode takes 2 bytes per character.
c. While Varchar accepts only Ascii data, NVarchar accepts both Ascii and Unicode data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you know about normalization and de- normalization?
Why Master database is required?
What are the different types of subquery?
What options are available to audit login activity? : sql server security
Explain what is scheduled job and how to create it?
Can you please explain the difference between primary keys and foreign keys?
How can delete duplicate records in cte in sql server?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What are the different ways you can create databases in sql server?
Does group by sort data?
What do you mean by an execution plan?
How to create database with physical files specified in ms sql server?
What is a collation?
What is the server name in sql server?
Do you know what is a with(nolock)?