What is the difference between varchar and nvarchar types?
Answer / 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 |
How to return the top 5 rows from a select query in ms sql server?
What is raid and what are different types of raid levels?
Can one drop a column from a table?
Explain the categories of stored procedure?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is difference between clustered and non clustered index?
How do I view views in sql server?
What are the types of table?
What is set nocount on?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Define Check points and End Points?
What are the restraints imposed on the table design by a merge replication?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)