O'Reilly logo
  • Peng Zhang thinks this is interesting:

Storing the value 'hello' requires the same amount of space in a VARCHAR(5) and a VARCHAR(200) column. Is there any advantage to using the shorter column?


Cover of High Performance MySQL, 3rd Edition


The take away is that one should be always aware of the possible length of data to be stored. It makes differences.