What is the difference between CHAR and VARCHAR in MySQL?

  • CHAR can have a maximum of 255 characters, but VARCHAR can hold a maximum of 65,535 characters.
  • CHAR field is a fixed length, but VARCHAR is a variable length field.
  • CHAR uses static memory allocation, but VARCHAR uses dynamic memory allocation.

Suggest An Answer

No suggestions avaliable!

Related Interview Questions