Re: cyrillic and sort order (ORDER BY) - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: cyrillic and sort order (ORDER BY)
Date
Msg-id Pine.LNX.4.30.0101022143150.758-100000@peter.localdomain
Whole thread Raw
In response to cyrillic and sort order (ORDER BY)  (Mihail Marinov <liahim@bcci.bg>)
Responses Re: cyrillic and sort order (ORDER BY)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Mihail Marinov writes:

> My problem is that ORDER BY does not alphabetically order strings in
> proper way. Worst - it does sometimes work right but I can't find out
> exactly why. But after a while it stops until I rebuild and
> reconfigure.

You must have the same collation locale setting (LC_COLLATE, or LC_ALL as
default) when running initdb and when running postmaster.  Changing the
setting in between will result in random and incorrect results and
database corruption.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Mihail Marinov
Date:
Subject: cyrillic and sort order (ORDER BY)
Next
From:
Date:
Subject: Re: How passwords can be crypted in postgres?