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 ...
regards, tom lane