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 is the usage of the sign function?
Do you have any idea about the tcl commands?
What is the new security features added in sql server 2016? : sql server security
What is normalization of database?
What happens to a trigger with multiple affected rows?
Explain about nested stored procedure?
What is difference between view and materialized view?
What happens when converting big values to integers?
Do you know what is a with(nolock)?
How to link tables in sql server?
What is the full form of dql?
What is acid properties?
What is the use of commit?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Distinguish between nested subquery and correlated subquery?