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.
BY Best Interview Question ON 01 Sep 2019