What is the difference between varchar and nvarchar types?
- 1 Answers
- 762 Views
- I also Faced
- E-Mail Answers
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 get the definition of a trigger back?
Diffrences between sql server 2000 vs 2005
Explain about the command-line tool SQLCMD?
How to Insert multiple rows with a single insert statement?
How to grant a permission in ms sql server using "grant execute" statements?
Can binary strings be used in arithmetical operations?
Explain primary key, foreign key and unique key?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How do I shrink an ldf file?
Find columns used in stored procedure?
What area unit the various kinds of info compression introduced in sql server 2008?
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
