[Bug localedata/1354] New: Problem in Turkish Locale Data (tr_TR.UTF-8 , Unicode)

[devrim at gunduz dot org]

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.

-- 
           Summary: Problem in Turkish Locale Data (tr_TR.UTF-8 , Unicode)
           Product: glibc
           Version: 2.3.4
            Status: NEW
          Severity: normal
          Priority: P2
         Component: localedata
        AssignedTo: libc-locales at sources dot redhat dot com
        ReportedBy: devrim at gunduz dot org
                CC: glibc-bugs at sources dot redhat dot com


http://sourceware.org/bugzilla/show_bug.cgi?id=1354

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.