John McCormack wants to store a single space in a CHAR(1) column:
I was asked by a colleague why his where clause wasn’t being selective when filtering on a space value. The column was a char(1) data type. To understand the curious case of the space in char(1), we need to understand how the char data type works and also a bit more about the need for it in this scenario.
The ANSI standard makes sense, but it is something you have to keep in mind in cases like this.