Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 5DF21633B09
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  3 Feb 2010 10:53:36 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 24893-02-2
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  3 Feb 2010 14:53:16 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by mail.postgresql.org (Postfix) with SMTP id 379C763396F
	for <pgsql-admin@postgresql.org>; Wed,  3 Feb 2010 10:53:25 -0400 (AST)
Received: (qmail invoked by alias); 03 Feb 2010 14:53:21 -0000
Received: from fsgw.f-secure.com (EHLO [10.128.134.211]) [193.110.108.33]
	by mail.gmx.net (mp051) with SMTP; 03 Feb 2010 15:53:21 +0100
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX1+ziy8j9LOzQwiRREWt7QMNMNUQt4G7HIBVcsC4Uo
	Dblka98J27wbiR
Subject: Re: Issues with LC_COLLATE, across 8.3/8.4 on various
 platforms
From: Peter Eisentraut <peter_e@gmx.net>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <201002021728.39492.achill@matrix.gatewaynet.com>
References: <201002021426.44936.achill@matrix.gatewaynet.com>
	<201002021728.39492.achill@matrix.gatewaynet.com>
Content-Type: text/plain; charset="UTF-8"
Date: Wed, 03 Feb 2010 16:53:20 +0200
Message-ID: <1265208800.10962.13.camel@fsopti579.F-Secure.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.28.2 
Content-Transfer-Encoding: 7bit
X-Y-GMX-Trusted: 0
X-FuHaFi: 0.69999999999999996
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.299 tagged_above=-10 required=5 tests=AWL=-1.114,
	BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 201002/37
X-Sequence-Number: 33640

On tis, 2010-02-02 at 17:28 +0200, Achilleas Mantzios wrote:
> It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD
> are two different stories, hence the seen results.

The UTF-8 locales on FreeBSD and Mac OS X are pretty much broken.

This is becoming a FAQ ...