Question 3 - CBSE Class 12 Sample Paper for 2022 Boards [Term 2] - Computer Science - Solutions to CBSE Sample Paper - Computer Science Class 12

Last updated at April 16, 2024 by Teachoo

Differentiate between char(n) and varchar(n) data types with respect to databases.

Answer

char(n)	varchar(n)
Char is a datatype in SQL which is used to store character/s or string of fixed length between 1 and 255 characters.	Varchar is a datatype in SQL which is used to store alphanumeric data of variable length but maximum length which is specified
In this, If the length of string is less than specified length then extra memory spaces is added automatically	In this, If the length of string is less than specified length then the string will be stored as it is i.e. no extra memory spaces.
In this, some space gets wasted	In this, no space gets wasted
Storage size of char data types is equal to n bytes i.e. specified length .	Storage size of varchar datatype is equal to the actual length of the entered string in bytes.