Re: How to setup a good collation?

From: Nagy László Zsolt <gandalf(at)shopzeus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to setup a good collation?
Date: 2016-03-06 09:40:31
Message-ID: 56DBFB0F.4080705@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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;

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nagy László Zsolt 2016-03-06 09:53:04 Re: How to setup a good collation?
Previous Message Nagy László Zsolt 2016-03-06 09:13:27 How to setup a good collation?