The differences between CHAR and VARCHAR are as follows,
- CHAR and VARCHAR types differ in retrieval and storage
- CHAR column length is fixed to the length that is declared while creating a table. The length value ranges from 1 and 255
- When CHAR values are stored then they are right padded using spaces to a specific length. Trailing spaces/Blank spaces are removed when CHAR values are retrieved