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 star, snowflake and star flake schema? : sql server analysis services, ssas
How to create an identity column?
What is a rollup clause?
Explain about Normalization?
When we should use @@error?
Are null values the same as that of zero or a blank space?
How to specify the collation for a character data type in ms sql server?
How to replace given values with null using nullif()?
What is read uncmmited?
Can an automatic recovery be initiated by a user?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is the maximum size of sql server database?
How can i Relate Tables in SSIS
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What encryption security is available in sql azure?