Re: BUG #2261: ILIKE seems to be buggy on koi8 input - Mailing list pgsql-bugs

Evgeny Gridasov <eugrid@fpm.kubsu.ru> writes:
> postgresql server starts with environment:
> LC_COLLATE=en_US.UTF-8
> LC_ALL=en_US.UTF-8
> LANG=en_US.UTF-8

Well, that setting shouldn't translate much except A-Z/a-z.  If you want
cyrillic upper/lower case conversions you need database's LC_CTYPE to be
ru_RU.something.

            regards, tom lane