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
How to change parameter value inside the report?
Why is normalisation important?
After removing a table from database, what other related objects have to be dropped explicitly?
Mention the differences between sql server and mysql.
List some advantages and disadvantages of stored procedure?
What are the components of dbms?
What are the advantages of sql azure?
How can you find out how many rows returned in a cursor?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What does the not null constraint do?
What is subquery? Explain the properties of a subquery?
How does a profiler work?
How efficient you are in oracle and SQL server?
Explain log shipping?
Tell me what are cursors and when they are useful?