Similarity :
(i) Both are used for storing non-numeric data.
(ii) Both can store 1 to 255 characters.
(iii) Values must be enclosed in single quotes or double quotes.
Difference :
CHAR |
VARCHAR |
Used for fixed-length string |
Used for variable length string |
Padded to the specified length when stored |
No padding takes place |