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 >