Turkish character sorting on PostgreSQL

[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 is like the following:

SELECT * from test order by name;
"id";"name"
1;"aa"
3;"dd"
6;"mm"
5;"zz"
2;"çç"
4;"ş"

There is no problem on Linux with the same data.
How can I solve this problem?

Thanks.

  

-- 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ http://www.enderunix.org/ismail  http://www.endersys.com.tr       +
+ EnderUNIX SDT @ Tr               Endersys Consultancy Ltd.        +
+ ismail ~ enderunix.org           ismail.yenigul ~ endersys.com.tr +
+ Volunteer, Core Team Member      Project Manager                  +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++