Re: Character collating order

Tom Lane wrote:

> Allan Engelhardt <allane@cybaea.com> writes:
> > I'm using the SQL_ASCII encoding, and un-setting the LANG environment
> > variable (which is the only locale variable set for the account; it
> > defaults to en_US) for postgres when starting postmaster does not fix
> > it.
>
> In 7.1, collation is determined by the locale variables seen at initdb
> time.  You probably need to re-initdb with LANG=C.  Try
> contrib/pg_controldata to verify the guess that the database's locale
> is not C ...

Bingo!  Re-init and re-start fixes the test script.  Now I just need to figure out how I want to run my
database.........

Thanks a million: you're a hero.


Allan.