MySQL - How do you enter a record with only whitespace " "?
You should use VARCHAR instead of CHAR for data type, if you want to store spaces. Space (whitespace) retention is documented in MySQL online documentation:


  The CHAR and VARCHAR types are similar, but differ in the way they are
  stored and retrieved. They also differ in maximum length and in
  whether trailing spaces are retained.