Re: Collation Order Change - Mailing list pgsql-general

From Tom Lane
Subject Re: Collation Order Change
Date
Msg-id 23964.1022077219@sss.pgh.pa.us
Whole thread Raw
In response to Collation Order Change  ("Len Morgan" <len-morgan@crcom.net>)
List pgsql-general
"Len Morgan" <len-morgan@crcom.net> writes:
> The problem shows up in names that contain more than one word.  It seems
> that the "new" alphabetical order doesn't look at spaces or dashes when
> deciding on order.  For example:

Sounds like you have selected a non-C locale (most likely en_US, which
is the system default in recent RH releases).  Unfortunately the only
way to change PG's locale is a fresh initdb :-(.  Try

    export LANG=C
    locale        --- make sure it says "C" for everything
    initdb

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql -l gives bad output
Next
From: Andrew Sullivan
Date:
Subject: Re: .doc .rtf database in PostgreSQL+PHP