Data Types MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Data Types
  4. Differences between CHAR and VARCHAR
Value CHAR(4) Storage Required VARCHAR(4) Storage Required
''' '4 bytes''1 byte
'ab''ab '4 bytes'ab'3 bytes
'abcd''abcd'4 bytes'abcd'5 bytes
'abcdefgh''abcd'4 bytes'abcd'5 bytes