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

AL ELK <ali@verus.com.tr>

From: "AL ELK" <ali@verus.com.tr>
To: pgsql-tr-genel@postgresql.org
Date: 2005-10-02T14:13:56Z
Lists: pgsql-bugs
:)))))))))))))))))))))))))))

Selamlar

12 gndr bu problem zerinde alyoruz. Projem iin Zeoslib 
kullanyordum. Sorun onda diye zeos u altn stne getirdim. Araya baka 
iler girdi ve ara verdim. Siz yaznca benim tekrar aklma geldi. Yaf 
PostgreSQL in byle basit bir hataya debileceini hi dnmemitim :(
Neyseki siz buldunuz da telef olmaktan kurtuldum.

yi almalar..

Ali ELK

"Devrim GUNDUZ" <devrim@gunduz.org>, haber iletisinde unlar 
yazd:Pine.LNX.4.63.0510020336270.25019@mail.kivi.com.tr...
>
> 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 Biliim Teknolojileri - http://www.kivi.com.tr
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
>                       http://www.gunduz.org
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>