On Tue, May 26, 2026 at 06:19:56PM +0100, Gavin Smith wrote: > I think that we should not uppercase the index entries before getting the > collation key, except in the case of USE_UNICODE_COLLATION=0.
It has a performance cost (in C), which is visible now that getting the collation string is fast. > When using USE_UNICODE_COLLATION=0, it is fine to carry on doing it the way > we are currently doing it - uppercase before getting the sort keys. There > is no need for any extra complications to always get upper and lower case in > exactly the right order. What about not uppercasing in that case either? Setting USE_UNICODE_COLLATION=0 is likely to be rare, and choosen for speed in cases where the sort order is not so important. -- Pat
