Re: Multi-byte character case-folding - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Multi-byte character case-folding
Date
Msg-id 1469258.1594067631@sss.pgh.pa.us
Whole thread Raw
In response to Multi-byte character case-folding  (Thom Brown <thom@linux.com>)
Responses Re: Multi-byte character case-folding  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Thom Brown <thom@linux.com> writes:
> At the moment, only single-byte characters in identifiers are
> case-folded, and multi-byte characters are not.
> ...
> So my question is, do we yet have the infrastructure to make
> case-folding consistent across all character widths?

We still lack any built-in knowledge about this, and would have to rely
on libc, which means the results would likely be platform-dependent
and probably LC_CTYPE-dependent.

More generally, I'd be mighty hesitant to change this behavior after
it's stood for so many years.  I suspect more people would complain
that we broke their application than would be happy about it.

Having said that, we are already relying on towlower() in places,
and could do similarly here if we didn't care about the above issues.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Ajay Patel
Date:
Subject: Question: PostgreSQL on Amazon linux EC2
Next
From: Flavio Henrique Araque Gurgel
Date:
Subject: Re: Question: PostgreSQL on Amazon linux EC2