| 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.
| 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 |
| 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 |