Question

Explain the differences between char and varchar data types explain with example

Answer 1

CHAR is fixed length and VARCHAR is variable length. CHAR always uses the same amount of storage space per entry, while VARCHAR only uses the amount necessary to store the actual text. ... Because char is a fixed-length data type, the storage size of the char value is equal to the maximum size for this column.