Subject: Re: How to setup a good collation?
To: pgsql-admin@postgresql.org
References: <56DBF4B7.1050200@shopzeus.com>
From: =?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= <gandalf@shopzeus.com>
Message-ID: <56DBFB0F.4080705@shopzeus.com>
Date: Sun, 6 Mar 2016 10:40:31 +0100
MIME-Version: 1.0
In-Reply-To: <56DBF4B7.1050200@shopzeus.com>
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

To answer my own question: it seems that the problem is not with
postgresql but with the FreeBSD OS. FreeBSD does not support sorting by
unicode characters, so I need to recompile the postgresql server with
"use ICU for unicode collation" flag.

2016.03.06. 10:13 keltezéssel, Nagy László Zsolt írta:
> Example database on a Unix system:
>
> CREATE DATABASE test
>        TEMPLATE = template0
>        ENCODING = 'UTF8'
>        LC_COLLATE = 'hu_HU.UTF-8'
>        LC_CTYPE = 'hu_HU.UTF-8'
>        CONNECTION LIMIT = -1;


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin