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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-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

Browse pgsql-bugs by date

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

Browse pgsql-tr-genel by date

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