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


Please Help Members By Posting Answers For Below Questions

What is the usage of the sign function?

710


Do you have any idea about the tcl commands?

716


What is the new security features added in sql server 2016? : sql server security

790


What is normalization of database?

768


What happens to a trigger with multiple affected rows?

691






Explain about nested stored procedure?

780


What is difference between view and materialized view?

701


What happens when converting big values to integers?

729


Do you know what is a with(nolock)?

793


How to link tables in sql server?

657


What is the full form of dql?

705


What is acid properties?

778


What is the use of commit?

735


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

646


Distinguish between nested subquery and correlated subquery?

751