"Niclas Gustafsson" <niclas(dot)gustafsson(at)codesense(dot)com> writes:
> Well I changed LC_ALL to LATIN1 and run initdb, dumped back all the
> data, but the sorting order seem to wrong still, allthough different,
> pg_controldata shows:
> LC_COLLATE: C
> LC_CTYPE: C
"C" is certainly not the locale you want...
regards, tom lane