Re: Sorting Problem

You mean in his own local environment? So all his programs, console operations, etc, will have the new encoding? Or
'LANG/LC_ALL'for Posgres specifically? 

Tom Lane wrote:

> Dennis Gearon <gearond@cvc.net> writes:
>
>>To help my understanding of this type of thing, when he reinits the database, can he get the PG backend to be running
witha different LOCALE than the machine's? 
>
>
> Yeah, he needs to set LANG and/or LC_ALL to be 'C' instead of whatever
> it's defaulting to on his machine.  Then run initdb with that
> environment, and he's set.
>
>             regards, tom lane
>