Re: BUG #17258: Unexpected results in CHAR(1) data type

> On Oct 29, 2021, at 3:13 PM, David G. Johnston  wrote:
> 
> For practical purposes you will frequently hit the one bit or the other.  
> 
> 
> As I noted in a prior reply, octet_length(char) does the length computation with the padding spaces.  So it is possible for char input functions to do the expected thing.

Yes, I saw that.  But there aren't that many functions like octet_length that do so.  If users coming from other RDBMSs expect CHAR(1) to behave as David expects them to behave, it's cold comfort to say, "hang in there, you can still use octet_length() on them!"  Better to say that they are going to be bitten by this expectation again and again, and instead choose a different datatype (which you also said.)


—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company