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: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Date: 2006-06-15 10:43:08
Message-ID: 20060615104308.GA2469@alamut.tdm.local (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-tr-genel
On Jun 14 05:00, Bruce Momjian wrote:
> Did we make any progress on this?  If so, I can't find it.

I've made some tests for upper(), lower(), ILIKE and ~* using cvs tip.
Below are the details:

  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 | FAILS | FAILS
     tr_TR.UTF-8 |            UTF8 |      OK |      OK | FAILS | FAILS

Also, if you'd wish, I can prepare an ad-hoc regression tests patch
for LATIN5 and UTF-8 support of Turkish characters.


Regards.

In response to

Responses

pgsql-tr-genel by date

Next:From: Tom LaneDate: 2006-06-15 13:33:33
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Bruce MomjianDate: 2006-06-14 21:40:05
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-06-15 13:33:33
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Emilia VenturatoDate: 2006-06-15 07:34:28
Subject: BUG #2481: select from table's join with geometries doesn't go

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