Bug 1354

Hi,

We are experiencing problems in Turkish locale. 

$ cat /etc/redhat-release
Red Hat Enterprise Linux ES release 4 (Nahant Update 1)
$ rpm -qv glibc
glibc-2.3.4-2.9

Here is a short description of our problem:

==========================================================
test=# SELECT * from unicode_test WHERE a ILIKE 'ö%';
 a
----
 ös
(1 row)

test=# SELECT * from unicode_test WHERE a ILIKE 'Ö%';
 a
---
(0 rows)

test=#
==========================================================

Now details:

In Turkish, we have a special letter called "ö" (o with dots on it). The capital
of it is also "Ö" (O (capital o) with dots on it. Same stands for i and İ, ı and I.

I'm using PostgreSQL 8.0.3. PostgreSQL relies on the operating system for string
operations. So if there is something wrong in glibc, PostgreSQL also fails on
that locale.

As you can see in the short description, the ILIKE (Incasensitive LIKE) cannot
find the correct result. The same problem stands for i and i dotless (İ and I,
respectively). Both database queries should return the same result.

I hope this can be fixed in the next release of glibc.