What is the difference between CHAR and VARCHAR?

Beginner

Answer

  • CHAR: Fixed-length string, padded with spaces, faster for fixed-size data, uses more storage
  • VARCHAR: Variable-length string, stores actual length + data, more storage efficient
-- CHAR always uses 10 bytes
name CHAR(10)

-- VARCHAR uses 1-255 bytes + length bytes
name VARCHAR(255)