Skip site navigation (1) Skip section navigation (2)

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

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Date: 2006-09-05 08:19:42
Message-ID: 20060905081942.GD1369@alamut (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-tr-genel
On Sep 04 02:35, Tom Lane wrote:
> "Devrim GUNDUZ" <devrim(at)gunduz(dot)org> writes:
> > Like the bug report that was submitted a few days ago,
> > http://archives.postgresql.org/pgsql-bugs/2005-09/msg00233.php
> > I have the same thing for Turkish locale.
> 
> Would you confirm that this is fixed by my recent commit?

I've made some tests. [AFAICS, below results are applicable for all
latinN encodings.]

  Cluster Locale | client_encoding | upper() | lower() | ILIKE | ~*
-----------------+-----------------+---------+---------+-------+----
 tr_TR.iso8859-9 |          LATIN5 |      OK |      OK |    OK |    OK
 tr_TR.iso8859-9 |            UTF8 |      OK |      OK |    OK |    OK
     tr_TR.UTF-8 |          LATIN5 |      OK |      OK |    OK | FAILS
     tr_TR.UTF-8 |            UTF8 |      OK |      OK |    OK | FAILS

Looks like regex code needs same modifications done to ILIKE command.


Regards.

In response to

Responses

pgsql-tr-genel by date

Next:From: Volkan YAZICIDate: 2006-09-05 08:23:56
Subject: Re: Türkçe'de ILIKE-LIK
Previous:From: Volkan YAZICIDate: 2006-09-05 07:58:41
Subject: Re: UNICODE veri tabanı

pgsql-bugs by date

Next:From: Victor SnezhkoDate: 2006-09-05 09:26:22
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Wei SongDate: 2006-09-05 06:31:24
Subject: Re: Hanging queries on Windows 2003 SP1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group