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 do you delete duplicate rows in sql server?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What are the different types of normalization?
How to get the definition of a trigger back?
What is Cross Join
What are distinctive joins find as a part of sql?
What are diverse clauses that form a part of sql?
Explain filtered indexes benefits?
Do you know hot add cpu in sql server 2008?
What is abstracting periodical?
How to create a new login name in ms sql server?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Oracle (3253)
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)