Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2317: Wrong sorting order for (VW) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2317: Wrong sorting order for (VW)
Date
Msg-id 10939.1142470789@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2317: Wrong sorting order for (VW)  ("TomasKlockar" <tomask@omicron.se>)
List pgsql-bugs
Tree view 
"TomasKlockar" <tomask@omicron.se> writes:
> I think the database was initialized with UTF8 but it might have been
> ISO_8859-1, however the error is easily repeatable and ill be happy to
> provide a dump.

If the database encoding doesn't match the database locale (server
LC_COLLATE setting), all kinds of very strange sorting behavior can
ensue.  I suspect you've been bit by this gotcha.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2319: psql utf8/latin1 client_encoding bug when using '-c'
Next
From: Tom Lane
Date:
Subject: Re: BUG #2316: problems when Restore Backup in RHEL4