Mysql: varchar(100) vs varchar(200) - space question.?

You are not right. If you look at your example, you have CHAR(4) and VARCHAR(4) basically the same size. VARCHAR adds a few bites for overhead. If you store 'hello in VARCHAR(10000) it is going to block out 10001 bytes also known as a crap load of wasted space.