Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between varchar and nvarchar types?

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


Please Help Members By Posting Answers For Below Questions

What do you know about normalization and de- normalization?

925


Why Master database is required?

1141


What are the different types of subquery?

1158


What options are available to audit login activity? : sql server security

1152


Explain what is scheduled job and how to create it?

954


Can you please explain the difference between primary keys and foreign keys?

1110


How can delete duplicate records in cte in sql server?

964


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

110


What are the different ways you can create databases in sql server?

1102


Does group by sort data?

898


What do you mean by an execution plan?

1115


How to create database with physical files specified in ms sql server?

993


What is a collation?

1092


What is the server name in sql server?

1010


Do you know what is a with(nolock)?

1057