Example & Tutorial understanding programming in easy ways.

Difference between CHAR and VARCHAR in MySQL ?

The differences between these data types are mentioned below: 

-CHAR data type is used to store fixed-length string data and VARCHAR data type is used to store variable-length string data. 

-The storage size of CHAR data type will always be the maximum length of this data type and the storage size of VARCHAR will be the length of the inserted string data. 

-Hence, it is better to use the CHAR data type when the length of the string will be the same length for all the records. 

-CHAR is used to store small data whereas VARCHAR is used to store large data. CHAR works faster and VARCHAR works slower.