What is the difference between CHAR and VARCHAR?

1.	What is the difference between CHAR and VARCHAR?
Answer» As the NAME suggests, the main DIFFERENCE is that CHAR is of fixed length whereas VARCHAR is of variable length. This means that char always has a fixed length to store the text whereas the VARCHAR adjusts its length ACCORDING to the length of the text and this helps in SAVING the memory. Also, the CHAR data TYPE can have a maximum size of 254 bytes whereas VARCHAR can have a maximum size of 4046 bytes.

Discussion