Tuesday, November 30, 2021

difference between Varchar and nvarchar and char

 Varchar:-

  1. It is a variable that has a length data type.
  2. It is use to store non-Unicode characters.
  3. It Occupy 1 byte of space for each character.

Nvarchar:- 
  1. It is a variable that has length data type.
  2. It is use to store Unicode characters.
  3. It Occupy 2 bytes of space for each character.

Char:-
  • It is a fixed length data type
  • Used to store non-Unicode characters
  • Occupiers 1 byte of space for each character

No comments:

Post a Comment