Re: BUG #1996: DISTINCT fails with national character varying - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1996: DISTINCT fails with national character varying
Date
Msg-id 8528.1130207618@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1996: DISTINCT fails with national character varying  ("Ludmil Tinkov" <ludmil@fyrex.com>)
List pgsql-bugs
"Ludmil Tinkov" <ludmil@fyrex.com> writes:
> select distinct name from depression

> --the last statement returns only a single row
> --namely: Ана
> --it should return 4 rows!

This has been seen to happen when you select a database encoding that
does not match the encoding expected by the postmaster's LC_CTYPE locale
setting.  It's really a bug in the locale definitions, if you ask me,
but good luck getting the glibc guys to change those :-(.  In the
meantime, make sure your locale and encoding agree.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Ludmil Tinkov"
Date:
Subject: BUG #1996: DISTINCT fails with national character varying
Next
From: Klint Gore
Date:
Subject: Re: BUG #1993: Adding/subtracting negative time intervals