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 is

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[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 locale.h int main() { setlocale(LC_COLLATE, tr_TR.ISO8859-9); printf(%d\n,strcoll(ö, z));

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

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 result