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(