From owner-freebsd-database@FreeBSD.ORG  Wed Dec 19 20:42:42 2007
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id CF13816A41B
	for <freebsd-database@freebsd.org>;
	Wed, 19 Dec 2007 20:42:42 +0000 (UTC)
	(envelope-from ismail@EnderUNIX.org)
Received: from istanbul.enderunix.org (freefall.marmara.edu.tr
	[193.140.143.23])
	by mx1.freebsd.org (Postfix) with ESMTP id 094E613C461
	for <freebsd-database@freebsd.org>;
	Wed, 19 Dec 2007 20:42:41 +0000 (UTC)
	(envelope-from ismail@EnderUNIX.org)
Received: (qmail 89273 invoked by uid 1040); 19 Dec 2007 20:15:02 -0000
Received: from unknown (HELO ISMAIL) (ismail@127.0.0.1) by 0 with ESMTPA;
	19 Dec 2007 20:15:00 -0000
Date: Wed, 19 Dec 2007 22:14:24 +0200
From: Ismail YENIGUL <ismail@EnderUNIX.org>
X-Mailer: The Bat! (v3.99.3) Professional
Organization: EnderUNIX
X-Priority: 3 (Normal)
Message-ID: <1605513356.20071219221424@EnderUNIX.org>
To: freebsd-database@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1254
Content-Transfer-Encoding: quoted-printable
X-SMTP-Filter: SurGATE SMTP Filter Engine Release 1.0.1 http://www.endersys.com
X-SurGATE-Result: Clean (Content eval: -4.40 points)
Cc: freebsd-questions@freebsd.org
Subject: Turkish character sorting on PostgreSQL
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: Ismail YENIGUL <ismail@EnderUNIX.org>
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 19 Dec 2007 20:42:42 -0000

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                  +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++