Re: Problem in order by

On Mon, 11 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:

> Hi Stephan, tks
>
> I drop database and move directory data to data01.
> I already executed "initdb --locale=C" and the file postgresql.conf change
> to LC_MESSAGES, LC_MONETARY, LC_NUMERIC and LC_TIME = 'C', but the problem
> persist.


I think LC_COLLATE would be the one that is the issue, but --locale=C
should have done it I think.  To be sure, what does "show LC_COLLATE;"
give on the database that has the problem?