Writing a NULL in a CHAR field

[Andrew Kuebler]

Are BLOB column types the only columns that will let you write a NULL
(Hexidecimal 0) and still write beyond that?
CHAR, CHAR BINARY, VARCHAR, and VARCHAR BINARY all seem to truncate the
string and stop at the first null even if I escape the string being
updated.
 
I don't want to use a BLOB column because I'm only writing 8 characters.
extreme waste of space.
 
Thanks for any help.
Best Regards,
Andrew 
Sql, query