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@postgresql.org  Sun Oct  2 00:14:30 2005
X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.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@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@gunduz.org>
Cc: pgsql-bugs@postgresql.org, pgsql-tr-genel@postgresql.org
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale 
In-reply-to: <Pine.LNX.4.63.0510020336270.25019@mail.kivi.com.tr> 
References: <20051001153536.6C9EBF0B6F@svr2.postgresql.org> <9028.1128184301@sss.pgh.pa.us> <Pine.LNX.4.63.0510020336270.25019@mail.kivi.com.tr>
Comments: In-reply-to Devrim GUNDUZ <devrim@gunduz.org>
	message dated "Sun, 02 Oct 2005 03:38:01 +0300"
Date: Sat, 01 Oct 2005 23:14:13 -0400
Message-ID: <29723.1128222853@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.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@gunduz.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