From owner-freebsd-database@FreeBSD.ORG Tue Sep 18 14:26:46 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 CD30516A418 for ; Tue, 18 Sep 2007 14:26:46 +0000 (UTC) (envelope-from netslists@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by mx1.freebsd.org (Postfix) with ESMTP id 652D013C480 for ; Tue, 18 Sep 2007 14:26:46 +0000 (UTC) (envelope-from netslists@gmail.com) Received: by nf-out-0910.google.com with SMTP id b2so1428566nfb for ; Tue, 18 Sep 2007 07:26:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=L37ApKhaETpAXrZ5Yhop2K3U2pUdjFWhVd+81ZRSPpU=; b=f+cqMvtmOB3pY9L1b2mYrWiUv6DD9pMoHuc4OD9lpV7pG3CCtaE+iBphB6yMVycVass7I4hgnmE4WYH5lOE6G5J9LcjuLWKeXvsj8jVHVYr7hgA4ZHKE736sBPvb/JzavnIVuHzndsfDPK+xPi9CPXCfop+eH8+Otrcs4ZO+JNA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=Ec6H2bUQsJ/sYoqzUIdhK5wM5JSvshVRW5zQUBx5hQpC29qWJxQI53AqkOSYmYUTadtxVei/gdAJ5RRSofWkLwTFy/tUZNHy1leYQ6Xi2qBdhClb8jewHOa26jZdxsPjbq8A+w5glecx79/T/0HVGscxWfrwJ/mLUq6M1lE9Ezg= Received: by 10.86.71.1 with SMTP id t1mr4686521fga.1190125604998; Tue, 18 Sep 2007 07:26:44 -0700 (PDT) Received: from ?192.168.9.8? ( [91.135.49.10]) by mx.google.com with ESMTPS id i8sm4840913nfh.2007.09.18.07.26.43 (version=SSLv3 cipher=RC4-MD5); Tue, 18 Sep 2007 07:26:44 -0700 (PDT) Message-ID: <46EFE01E.8090603@gmail.com> Date: Tue, 18 Sep 2007 16:26:38 +0200 From: Sten Daniel Soersdal User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Ivan Voras References: <46EE897B.7000107@gmail.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org Subject: Re: Enabling norwegian sorting rules in 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: Tue, 18 Sep 2007 14:26:46 -0000 Ivan Voras wrote: > Sten Daniel Soersdal wrote: >> >> Does anyone know how to enable norwegian sorting rules for PostgreSQL >> (8.2.4) on FreeBSD 6.x ? >> >> I've tried just about everything i can think of, but the extra three >> letters just wont be sorted right. > > You'll probably need the ICU patch for PostgreSQL, which is > unfortunately only available for 8.1.x - maybe you can bug the developer > to provide it for newer versions of PostgreSQL. > Actually, i tried that and that didn't help at all. Granted that was with UTF-8. I came across an old open PR (51920) that adds Norwegian Collate (ISO8859-1 + ISO8859-15) support to FreeBSD. Now my console and my postgresql sorts correctly. I just hope someone would commit this support to the tree. The LATIN-1 / la_LN.ISO8859-1 collate is not right for norwegian alphabet. http://www.freebsd.org/cgi/query-pr.cgi?pr=conf/51920 -- Sten Daniel Soersdal