What is the difference between varchar and nvarchar types?

Question Posted / dalveer singh

1 Answers
1582 Views
I also Faced
E-Mail Answers

What is the difference between varchar and nvarchar types?..

Answer / 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

More SQL Server Interview Questions

What is PROJECTION Operation?

0 Answers Infosys,

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers

Explain DBCC?

0 Answers QuestPond,

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers TCS,

what is the difference between count(*) and count(1) ?

0 Answers MCN Solutions,

How can we write or define DDL statements in Sql server and DML statements?

3 Answers

Explain datetime2 data type in sal server 2008?