Skip to content
- CHAR and VARCHAR have differed in storage and retrieval.
- CHAR column length is fixed, while VARCHAR length is variable.
- The maximum no. of character CHAR data types can hold is 255 characters, while VARCHAR can hold up to 4000 characters.
- CHAR is 50% faster than VARCHAR.
- CHAR uses static memory allocation, while VARCHAR uses dynamic memory allocation.