Pages

Thursday 16 August 2012

Difference Between Sql Server VARCHAR and NVARCHAR Data Type


Difference Between Sql Server VARCHAR and NVARCHAR Data Type





The abbreviation for Varchar is non-Unicode Variable Length character String.

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

Differences :

Character Data Type
Varchar - Non-Unicode Data 
NVarchar - Unicode Data

2 Character Size 
Varchar - 1 byte
NVarchar - 2 bytes

3 Maximum Length 
Varchar - 8,000 bytes
NVarchar - 4,000 bytes

4 Storage Size 
Varchar - Actual Length (in bytes)
NVarchar - 2 times Actual Length (in bytes)



No comments:

Post a Comment