title: Can you set a CHAR to NULL or an empty string?
body: <p>I haven't used CHAR much in the past as I seemed to use VARCHAR too much; I'm trying to use CHAR when appropriate lately &amp; from what I understand you use it when the data is all the same length in that certain column (else it is padded with spaces).</p>
  
  <p>Because all the data is supposed to be the same length I was wondering can a CHAR field be NULL or an empty string? Such for cases when that specific field doesn't have a value whilst others do.</p>