CHAR VS VARCHAR:

CHAR VS VARCHAR: CHAR Used to store character string value of fixed length. The maximum no. of characters the data type can hold is 255 characters. It's 50% faster than VARCHAR. Uses static memory allocation. VARCHAR Used to store variable length alphanumeric data. The maximum this data type can hold is up to 4000 characters. It's slower than CHAR. Uses dynamic memory allocation