What is the difference between varchar and nvarchar types?
- 1 Answers
- 774 Views
- I also Faced
- E-Mail Answers
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 replace and stuff function in sql server?
Write a sql query to sort on different column name according to the parameters passed in the function?
How to list all field names in the result set using mssql_field_name()?
Is it possible in sql table to have more than one foreign key?
Can select statements be used on views in ms sql server?
Explain the relational database management system (rdbms)?
can we have a nested transaction? : Sql server database administration
Do you know the different ddl commands in sql?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
what is isolation level at dead lock?
How to download microsoft sql server 2005 express edition?
Is it possible for a stored procedure to call itself or recursive stored procedure?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What are the components of sql server service broker?
When would you use a before or after trigger?
