1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between varchar and nvarchar types?

Question Posted / dalveer singh


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

Benefits of Stored Procedures?

0 Answers   Wipro,

What is db stored procedure?

0 Answers  

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

What is tablesample?

0 Answers  

what are the limitations of parameters in a storedprocedure

1 Answers  




What is a virtual table in sql?

0 Answers  

What does it mean to invest in the index?

0 Answers  

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

How do you set a trace flag in sql server?

0 Answers  

How to find the list of fixed hard drive and free space on server?

0 Answers  

what is an sql server?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories