> > I made a reproduceable example of things going wrong with a "en_US"
> > locale which is the widely-used (single-byte) ISO-8859-1 Latin 1 charset.
>
> en_US uses multi-pass collation rules. It's those collation rules, not
> the charset per se, that causes the problem.
Just to understand things correctly. Is the Like optimization disabled
for all non-ASCII char sets, or (imho correctly) for non charset ordered
collations (LC_COLLATE) ?
Thus can you enable index optimization by simply setting
LC_COLLATE to C if your LANG is not set to C ?
Andreas
