Whais difference in char, varchar and nvarchar ?

On By Upendra RawatIn SQL Server

Char:

  1. It is used for fixed length.
  2. Char is not memory efficient I’d data in column varying in size.

Varchar:

  1. Takes 1 byte per char.
  2. VARCHAR is used for Variable Length Size Variable.
  3. It is memory efficient.
  4. It support non-unicode data.

Nvarchar:

  1. Takes 2 byte per char.
  2. NVARCHAR is used for Variable Length Size Variable.
  3. A nvarchar column can store any Unicode data

Leave a comment