Re: BUG #2317: Wrong sorting order for (VW)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "TomasKlockar" <tomask(at)omicron(dot)se>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2317: Wrong sorting order for (VW)
Date: 2006-03-16 00:59:49
Message-ID: 10939.1142470789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"TomasKlockar" <tomask(at)omicron(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-03-16 01:04:31 Re: BUG #2316: problems when Restore Backup in RHEL4
Previous Message Tom Lane 2006-03-16 00:56:28 Re: BUG #2319: psql utf8/latin1 client_encoding bug when using '-c'