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.
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 |