Monday, 1 August 2011

Difference between Varchar and NVarchar in SQL Server.

Tags : Varchar ,NVarchar ,Varchar(n),NVarchar(n),SQL Server,String,Length,Difference.

Hi Friends,in this post i would like to explain difference between Varchar
& NVarchar in SQL Server.

The data type Varchar and NVarchar are the sql server data types, both will used to store the string values.

Differences :

Character Data Type

Varchar - Non-Unicode Data
NVarchar - Unicode Data

2 Character Size

Varchar - 1 byte
NVarchar - 2 bytes

3 Maximum Length

- 8,000 bytes
NVarchar - 4,000 bytes

4 Storage Size

Varchar - Actual Length (in bytes)
NVarchar - 2 times Actual Length (in bytes)

* The abbreviation for Varchar is Variable Length character String.

* The abbreviation of NVarchar is uNicode Variable Length character String.

Thank You...
Shout it

2 Responses so far.

  1. Anonymous says:

    your Explanation was so helpful..

  2. Anonymous says:

    good one, simple and straight to the point

Leave a Reply