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?
The take away is that one should be always aware of the possible length of data to be stored. It makes differences.
Share this highlighthttp://www.safaribooksonline.com/a/high-performance-mysql/10122893/