From owner-freebsd-database@FreeBSD.ORG Mon Sep 17 14:31:18 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 6874116A419 for ; Mon, 17 Sep 2007 14:31:18 +0000 (UTC) (envelope-from netslists@gmail.com) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.190]) by mx1.freebsd.org (Postfix) with ESMTP id A987A13C46A for ; Mon, 17 Sep 2007 14:31:17 +0000 (UTC) (envelope-from netslists@gmail.com) Received: by fk-out-0910.google.com with SMTP id b27so2094892fka for ; Mon, 17 Sep 2007 07:31:08 -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:subject:content-type:content-transfer-encoding; bh=Dnn4FOZoZYeSdJ7n9V3Lbctt7OzoweZ6sogXR4w2E3Y=; b=nrtUolEMXioCTibpvkoySAzXQj+PrcBnyatOJa1fDPIV3tboTdnHuOvzrNzqRNitEZYwxBG526a7J02O2HyZXSCO3N2Qa5C5BXywxOo8ye/abkiQwzufQsUpD4glvHMgMI3pINiW7mveN5dlJQ0ZBsnrat+PQkQqT9n2Z30J5Tw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=MBb63FEukAFgNjWJr9xWmzr+njXyM9iENgrDS5t8aX3tU30/fiGuoOszDkdkWRFsEuh2VtyvvnJkhFZqc9cUQqk1pXg7RauwDy/B4jS+k5+Ej1ygi4lj213B5MexIHmBlR2zImwd9NDWvWqqUo62aFpfZC7IA5aJ9cJskTCg1+8= Received: by 10.82.119.17 with SMTP id r17mr5509760buc.1190037887222; Mon, 17 Sep 2007 07:04:47 -0700 (PDT) Received: from ?192.168.9.8? ( [91.135.49.10]) by mx.google.com with ESMTPS id c9sm3605696nfi.2007.09.17.07.04.45 (version=SSLv3 cipher=RC4-MD5); Mon, 17 Sep 2007 07:04:46 -0700 (PDT) Message-ID: <46EE897B.7000107@gmail.com> Date: Mon, 17 Sep 2007 16:04:43 +0200 From: Sten Daniel Soersdal User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: freebsd-database@freebsd.org Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Subject: 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: Mon, 17 Sep 2007 14:31:18 -0000 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. -- Sten Daniel Soersdal From owner-freebsd-database@FreeBSD.ORG Tue Sep 18 13:12:47 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 BA97016A41A for ; Tue, 18 Sep 2007 13:12:47 +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 7504013C45D for ; Tue, 18 Sep 2007 13:12:47 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1IXc3e-0005P1-Ce for freebsd-database@freebsd.org; Tue, 18 Sep 2007 14:20:02 +0200 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 ; Tue, 18 Sep 2007 14:20:02 +0200 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 18 Sep 2007 14:20:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: Ivan Voras Date: Tue, 18 Sep 2007 11:54:35 +0200 Lines: 34 Message-ID: References: <46EE897B.7000107@gmail.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enig2E0FA6B5BEFEDC7650EFC1AA" X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 1.5.0.12 (X11/20060911) In-Reply-To: <46EE897B.7000107@gmail.com> X-Enigmail-Version: 0.94.4.0 Sender: news 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 13:12:47 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2E0FA6B5BEFEDC7650EFC1AA Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Sten Daniel Soersdal wrote: >=20 > Does anyone know how to enable norwegian sorting rules for PostgreSQL=20 > (8.2.4) on FreeBSD 6.x ? >=20 > I've tried just about everything i can think of, but the extra three=20 > letters just wont be sorted right. You'll probably need the ICU patch for PostgreSQL, which is=20 unfortunately only available for 8.1.x - maybe you can bug the developer = to provide it for newer versions of PostgreSQL. --------------enig2E0FA6B5BEFEDC7650EFC1AA Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFG76BcldnAQVacBcgRA69EAJ4xujWfWjLBofteFLzV3RbgjLvK7gCg63Fv wjXCcp/VhTtm+/IXDzt4e0U= =DK9z -----END PGP SIGNATURE----- --------------enig2E0FA6B5BEFEDC7650EFC1AA-- 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