What is the difference between CHAR and VARCHAR?
- A CHAR is fixed length and space padded; VARCHAR is variable length
- B VARCHAR is fixed length; CHAR is variable
- C They are identical
- D CHAR can only store numbers
Answer
CHAR is fixed length and space padded; VARCHAR is variable length
CHAR always occupies its declared width. VARCHAR stores a length prefix plus the actual characters, which is more efficient for values of varying length.





