From owner-freebsd-database@FreeBSD.ORG Thu Dec 20 10:45:00 2007 Return-Path: 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 C2EA416A468 for ; Thu, 20 Dec 2007 10:45:00 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 7EE0813C442 for ; Thu, 20 Dec 2007 10:45:00 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1J5ItS-00082M-Bh for freebsd-database@freebsd.org; Thu, 20 Dec 2007 10:44:46 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 20 Dec 2007 10:44:46 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 20 Dec 2007 10:44:46 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: Ivan Voras Date: Thu, 20 Dec 2007 11:44:34 +0100 Lines: 40 Message-ID: References: <1605513356.20071219221424@EnderUNIX.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig2D5D61E373CCE333278A2402" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.6 (X11/20070801) In-Reply-To: <1605513356.20071219221424@EnderUNIX.org> X-Enigmail-Version: 0.95.3 Sender: news Cc: freebsd-questions@freebsd.org Subject: Re: Turkish character sorting on PostgreSQL X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Dec 2007 10:45:00 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2D5D61E373CCE333278A2402 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Ismail YENIGUL wrote: > Hello, >=20 > 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: >=20 > initdb -E UNICODE --locale=3Dtr_TR.UTF-8 and Unicode (UTF-8) collations (sorting) don't work on FreeBSD. You can use PostgreSQL 8.1 and the "ICU" patch for it. > initdb -E LATIN5 --locale tr_TR.ISO8859-9 This could work, if the locale is properly defined in the system locale database. Try creating a small C program that sorts your strings using strcoll() to verify this - if the small C program works, it's a PostgreSQL problem. --------------enig2D5D61E373CCE333278A2402 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHakeSldnAQVacBcgRAqLdAJ9D9V4jzyqrZprh2bZkLz3A8rZqwgCdF28G uXG1sG3Ell5APk953LdgcaU= =8VQB -----END PGP SIGNATURE----- --------------enig2D5D61E373CCE333278A2402--