Re[4]: Turkish character sorting on PostgreSQL

2007-12-23 Thread Ismail YENIGUL
Hello, I think, I managed to give full Turkish locale support by modifying /usr/src/share/colldef/la_LN.ISO8859-1.src file. I made some tests, It is working fine. I will submit a new PR. Also please find the attached patch for the people who want to test it. Sunday, December 23, 2007, 12:35:08

Re[4]: Turkish character sorting on PostgreSQL

2007-12-23 Thread Ismail YENIGUL
Hello, I am volunteer for this issue. But, I don't know how to create a locale Can someone give me hints(url, howto etc) about this issue? Thanks in advance. Sunday, December 23, 2007, 12:35:08 AM, you wrote: > On 22/12/2007, Ismail YENIGUL <[EMAIL PROTECTED]> wrote: >> By the way, LC_COLLATE

Re: Re[2]: Turkish character sorting on PostgreSQL

2007-12-22 Thread Ivan Voras
On 22/12/2007, Ismail YENIGUL <[EMAIL PROTECTED]> wrote: > By the way, LC_COLLATE is link to the ../la_LN.US-ASCII/LC_COLLATE > in /usr/share/locale/tr_TR.ISO8859-9 directory. Does this mean that > LC_COLLATE is missing for tr_TR.ISO8859-9 ? Yes. __

Re[2]: Turkish character sorting on PostgreSQL

2007-12-22 Thread Ismail YENIGUL
Hello Ivan, Here is the test result. It seems that the problem is on FreeBSD (6.2) . Because ö and ş are before then z in Turkish alphabet. # cat a.c #include int main() { setlocale(LC_COLLATE, "tr_TR.ISO8859-9"); printf("%d\n",strcoll("ö", "z")); printf("%d\n",strcoll(

Turkish character sorting on PostgreSQL

2007-12-19 Thread Ismail YENIGUL
Hello, I am using PostgreSQL 8.2.5 on FreeBSD 6.2. But I have a problem with sorting Turkish characters. They are listed after "z" character. I initialized the PostgreSQL with the following values: initdb -E UNICODE --locale=tr_TR.UTF-8 and initdb -E LATIN5 --locale tr_TR.ISO8859-9 But the resul