>I wonder if what he says about storing NULL in a char(255) column is true? He says that it will take up the entire 255 characters ... I'm wondering how a NULL can take up 255 characters?

Ignore this, it is a idiocy.

Until contrary test,
a NULL on VARCHAR(8000) or on VARCHAR(1) occupies the same space.