| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Snezhko | 2006-09-05 09:26:22 | Re: BUG #1931: ILIKE and LIKE fails on Turkish locale |
| Previous Message | Wei Song | 2006-09-05 06:31:24 | Re: Hanging queries on Windows 2003 SP1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2006-09-05 08:23:56 | Re: Türkçe'de ILIKE-LIK |
| Previous Message | Volkan YAZICI | 2006-09-05 07:58:41 | Re: UNICODE veri tabanı |