> However, I am wondering if we should create a character
> lookup during initdb that has the characters ordered so we can do:
>
> col LIKE 'ha%' AND col >= "ha" and col <= "hb"
>
> Could we do this easily for single-character encodings? We
> could have:
>
> A 1
> B 2
> C 3
>
> and a non-C locale could be:
>
> A 1
> A` 2
> B 3
>
> We can't handle multi-byte encodings because the number of
> combinations is too large or not known.
>
> Also, we mention you should use the "C" locale to use normal
> indexes for LIKE but isn't it more correct to say the
> encoding has to be SQL_ASCII?
Would it not be better to take this as an opportunity to integrate ICU ?
That would work with both single and multibyte encodings.
... John