Hi all:
I'm using Postgres-6.5.3 with Red Hat 6.0 and I've a problen using
LC_TYPE and LC_COLLATE ...
I compiled Postgres --wiht-locale --with-mb=LATIN1.
I did initdb -e LATIN1
And finally I createdb -E LATIN1 test.
I also have defined
LC_TYPE=LATIN1 and
LC_COLLATE=LATIN1
when postmaster starts.
So now, I try to select * from test1 order by ...
The problem is that I do not get the result sorted as I would.
What's wrong? What should I do?
Thanks to all,
jjprat