Re: Can LIKE under utf8 use INDEXes?

Robert James <srobertjames@gmail.com> writes:
> Hi.  I'm confused about the behavior of LIKE under utf8 locale.

UTF8 is not a locale, it's an encoding.  If you're using C locale then
LIKE can use indexes, regardless of the encoding.  If you're using
some other locale then you need a pattern_ops index.

            regards, tom lane