Answer:
1)Varchar takes 1 byte per character.NVarchar takes 2 bytes per Unicode/Non-Unicode character.
2)Varchar can store maximum 8000 Non-Unicode characters.NVarchar can store maximum 4000 Unicode/Non-Unicode characters.
3)Varchar takes no. of bytes equal to the no. of Characters entered plus two bytes extra for defining offset.NVarchar takes no. of bytes equal to twice the no. of Characters entered plus two bytes extra for defining offset.
Asked In: Many Interviews |
Alert Moderator