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 is star, snowflake and star flake schema? : sql server analysis services, ssas

1162


How to create an identity column?

1223


What is a rollup clause?

970


Explain about Normalization?

1069


When we should use @@error?

975


Are null values the same as that of zero or a blank space?

1040


How to specify the collation for a character data type in ms sql server?

1031


How to replace given values with null using nullif()?

994


What is read uncmmited?

1062


Can an automatic recovery be initiated by a user?

1018


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1266


What is the maximum size of sql server database?

1012


How can i Relate Tables in SSIS

1081


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

996


What encryption security is available in sql azure?

101