Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

Hi Tom,

On Sat, 1 Oct 2005, Tom Lane wrote:

<snip>
> So yeah, ILIKE looks just about completely broken for multibyte encodings.
> Maybe it would be best to pass both strings through lower() and then
> do a normal LIKE comparison?
>
> The regexp code doesn't look better, btw, just differently broken ...

So any chance to fix it before beta 3 (and also backpatch?) ?

Regards,
--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-bugs-owner(at)postgresql(dot)org Sun Oct 2 00:14:30 2005
X-Original-To: pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id 0E04ED8BF7;
Sun, 2 Oct 2005 00:14:21 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 37446-07; Sun, 2 Oct 2005 03:14:19 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
by svr1.postgresql.org (Postfix) with ESMTP id 59D05D889A;
Sun, 2 Oct 2005 00:14:18 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl(at)localhost [127.0.0.1])
by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j923EDNq029724;
Sat, 1 Oct 2005 23:14:15 -0400 (EDT)
To: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-tr-genel(at)postgresql(dot)org
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
In-reply-to: <Pine(dot)LNX(dot)4(dot)63(dot)0510020336270(dot)25019(at)mail(dot)kivi(dot)com(dot)tr>
References: <20051001153536(dot)6C9EBF0B6F(at)svr2(dot)postgresql(dot)org> <9028(dot)1128184301(at)sss(dot)pgh(dot)pa(dot)us> <Pine(dot)LNX(dot)4(dot)63(dot)0510020336270(dot)25019(at)mail(dot)kivi(dot)com(dot)tr>
Comments: In-reply-to Devrim GUNDUZ <devrim(at)gunduz(dot)org>
message dated "Sun, 02 Oct 2005 03:38:01 +0300"
Date: Sat, 01 Oct 2005 23:14:13 -0400
Message-ID: <29723(dot)1128222853(at)sss(dot)pgh(dot)pa(dot)us>
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level:
X-Archive-Number: 200510/5
X-Sequence-Number: 12986

Devrim GUNDUZ <devrim(at)gunduz(dot)org> writes:
> On Sat, 1 Oct 2005, Tom Lane wrote:
>> So yeah, ILIKE looks just about completely broken for multibyte encodings.
>> The regexp code doesn't look better, btw, just differently broken ...

> So any chance to fix it before beta 3 (and also backpatch?) ?

Are you volunteering?

This stuff has never worked, so I don't feel that it qualifies as "must
fix for 8.1". If you can come up with a believable low-impact patch,
I'd support putting it in now ... but my guess is that this is a
significant bit of work that will not get done in this release cycle.

regards, tom lane