Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1adyoF-0005RK-Vd for pgsql-admin@arkaria.postgresql.org; Thu, 10 Mar 2016 11:31:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1adyoF-0007eb-IB for pgsql-admin@arkaria.postgresql.org; Thu, 10 Mar 2016 11:31:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1adyoF-0007eJ-21 for pgsql-admin@postgresql.org; Thu, 10 Mar 2016 11:31:15 +0000 Received: from cerebro.liukuma.net ([185.34.0.166]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1adyo8-0002MR-Ac for pgsql-admin@postgresql.org; Thu, 10 Mar 2016 11:31:14 +0000 Received: from cerebro.liukuma.net (localhost [127.0.0.1]) by cerebro.liukuma.net (Postfix) with ESMTP id BD74B8B1725; Thu, 10 Mar 2016 13:31:06 +0200 (EET) DKIM-Filter: OpenDKIM Filter v2.10.3 cerebro.liukuma.net BD74B8B1725 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=liukuma.net; s=liukudkim; t=1457609466; bh=10TmiUTd9l/qilpwl2khbeVpX+sAQJXmq8S1E+QOntE=; h=From:To:References:In-Reply-To:Subject:Date; b=HJ3S6eN2ORF23YZ/MXflOTGtNL3keAF980q7psDrDER4ZQWh6P1CzBQn7eiinDslK w1DxqmYWY++g0k622hkk5aQeDlYDaeA/Fxuqv+80ecC6lOE3cMJp3lBBrf16TWUyF+ E91w4s6EJ7s5SiW54kwR8QWc69KbKsiKL12gFgRQ= X-Virus-Scanned: amavisd-new at liukuma.net Received: from cerebro.liukuma.net ([127.0.0.1]) by cerebro.liukuma.net (cerebro.liukuma.net [127.0.0.1]) (amavisd-new, port 10027) with LMTP id NvZX_G5rIsJY; Thu, 10 Mar 2016 13:31:05 +0200 (EET) Received: from Rivendell (dsl-kmibrasgw1-50dfdd-193.dhcp.inet.fi [80.223.221.193]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) (Authenticated sender: ignatz@cerebro.liukuma.net) by cerebro.liukuma.net (Postfix) with ESMTPSA id DCDBB8B1478; Thu, 10 Mar 2016 13:31:04 +0200 (EET) DKIM-Filter: OpenDKIM Filter v2.10.3 cerebro.liukuma.net DCDBB8B1478 Message-ID: From: "Reko Turja" To: , =?iso-8859-2?Q?Nagy_L=E1szl=F3_Zsolt?= References: <56DBF4B7.1050200@shopzeus.com> <56DBFB0F.4080705@shopzeus.com> <56DBFE00.40504@shopzeus.com> In-Reply-To: <56DBFE00.40504@shopzeus.com> Subject: Re: How to setup a good collation? Date: Thu, 10 Mar 2016 13:30:58 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-2"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Mailer: Microsoft Windows Live Mail 16.4.3564.1216 X-MimeOLE: Produced By Microsoft MimeOLE V16.4.3564.1216 X-Pg-Spam-Score: 0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > All right, I have reinstalled postgresql server with "Use ICU for > unicode collation" but it did not help! Postgres 9.3 on FreeBSD 10.2 with kernel, userland and software from ports compiled with clang. Server compile flags include ICU in addition of the defaults and client flags using non-GPL libedit instead of readline. test=# select name from a order by upper(name) asc; name ------ a á Á b e é É o ó ö U Ü Z (13 rows) test=# -Reko -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin