BUG #2261: ILIKE seems to be buggy on koi8 input

From: "Evgeny Gridasov" <eugrid(at)fpm(dot)kubsu(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2261: ILIKE seems to be buggy on koi8 input
Date: 2006-02-14 17:39:46
Message-ID: 20060214173946.3661AF0B05@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2261
Logged by: Evgeny Gridasov
Email address: eugrid(at)fpm(dot)kubsu(dot)ru
PostgreSQL version: 8.1.2
Operating system: Debian Linux
Description: ILIKE seems to be buggy on koi8 input
Details:

my terminal is RU_ru.KOI8-R,
template1's encoding is UTF8.
ILIKE seems to be buggy when comparing russian strings,
while UPPER/LOWER works OK.

template1=# \encoding koi8;

try to get uppercase of some russian letters:
template1=# select upper('');
upper
-------

(1 row)

result is OK!

next, try to compare uppercase and lowercase using
ILIKE:
template1=# select true where '' ilike '';
bool
------
(0 rows)

OOPS! Nothing happened. But why?

try the same but with latin charset letters:

template1=# select true where 'asdf' ilike 'ASDF';
bool
------
t
(1 row)

Try to compare lowercase with lowercase (russian):

template1=# select true where '' ilike '';
bool
------
t
(1 row)

it works.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Klosterman 2006-02-14 19:06:03 Re: BUG #2246: Bad malloc interactions: ecpg, openssl
Previous Message Daniel Blaisdell 2006-02-14 17:28:25 BUG #2260: PGCrypto Memory Problem