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

How many columns can exist together per table?

1205


What is the difference between Clustered and Non-Clustered Index?

1100


Can you explain powershell included in sql server 2008?

989


What is named calculation? : sql server analysis services, ssas

1021


How do you create type- insensitive operator?

1098


what are cursors? : Sql server database administration

1099


Explain trigger and trigger types?

1034


What are the different types of columns types constraints in the sql server?

1128


How to remove duplicate rows from table except one?

1060


List some advantages and disadvantages of stored procedure?

1063


How you can change a cross join into an inner join?

1020


How to send a ssrs report from ssis?

183


What purpose does the model database server?

1147


How many types of cursor type are there?

1162


Explain the Ways to improve the performance of a sql azure database?

84