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 |
Why should one not prefix user stored procedures with ‘sp_’?
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How to read data in a table with "select" statements?
What to check if a User database is locked?
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply
What are the 3 types of schema?
What are the restrictions that views have to follow?
What is replace and stuff function in sql server?
What is sub query and its properties?
What is difference between primary key and foreign key?
What do you mean by an execution plan? Why is it used?
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)