Re: collation & UTF-8 - Mailing list pgsql-general

From Tom Lane
Subject Re: collation & UTF-8
Date
Msg-id 4535.1140803871@sss.pgh.pa.us
Whole thread Raw
In response to Re: collation & UTF-8  (Tomi NA <hefest@gmail.com>)
List pgsql-general
Tomi NA <hefest@gmail.com> writes:
> You were right about this:
>  LC_ALL=3Dhr_HR.UTF-8 sort < test.txt
> (seemingly) collates the same way that pgsql does. Accented letters at the
> end of the alphabet. I've tried hr_HR.UTF8 as well, without results.

If you're not sure what locales are available on your system, run
"locale -a".  I don't think "sort" will complain about an unknown locale
setting, it'll probably just fall back to "C" locale.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ltree + gist index performance degrades significantly over a night
Next
From: Bruce Momjian
Date:
Subject: Re: Oracle purchases Sleepycat - is this the "other shoe"