Date: Wed, 19 Dec 2007 22:14:24 +0200 From: Ismail YENIGUL <ismail@EnderUNIX.org> To: freebsd-database@freebsd.org Cc: freebsd-questions@freebsd.org Subject: Turkish character sorting on PostgreSQL Message-ID: <1605513356.20071219221424@EnderUNIX.org>
next in thread | raw e-mail | index | archive | help
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=3Dtr_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;"=E7=E7" 4;"=FE" There is no problem on Linux with the same data. How can I solve this problem? Thanks. =20 --=20 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + 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 + +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1605513356.20071219221424>