Re: BUG #13997: does not work ILIKE + UTF8

On Thu, Mar 3, 2016 at 5:23 AM, <woodman(at)adea74(dot)ru> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 13997
> Logged by: Max
> Email address: woodman(at)adea74(dot)ru
> PostgreSQL version: 9.4.6
> Operating system: Centos 6
> Description:
>
> Hi, does not work ILIKE. Language - Russain, encoding - UTF8.
>

Hello,

In order to diagnose the issue, please provide a minimal SQL statement to
reproduce the issue, any error message you get or expected result vs.
actual result. Please also provide output of psql \l command on the
database where you experience the issue, e.g:

=# \l test_ilike
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
------------+----------+----------+---------+-------+-------------------
test_ilike | oshulgin | LATIN1 | C | C |
(1 row)

=# select 'тест' ilike 'ТЕСТ';
ERROR: character with byte sequence 0xd1 0x82 in encoding "UTF8" has no
equivalent in encoding "LATIN1"

--
Alex