What is the difference between CHAR and VARCHAR in MySQL?

1.	What is the difference between CHAR and VARCHAR in MySQL?
Answer» 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.

Discussion