Skip site navigation (1) Skip section navigation (2)

Re: BUG #1996: DISTINCT fails with national character varying

From: "Ludmil Tinkov" <ludmil(at)fyrex(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1996: DISTINCT fails with national character varying
Date: 2005-10-26 12:47:47
Message-ID: 898CCCAD9659C94EB671794CBD782F2C01282D@production.fyrex.dom (view raw or flat)
Thread:
Lists: pgsql-bugs
Thanks, Tom!

I'll tackle this issue this weekend. 
I'll also upgrade to PostgreSQL 8 (most probably)

Thanks once again for your comprehensive reply!

Best regards,
Ludmil Tinkov

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Tuesday, October 25, 2005 5:34 AM
To: Ludmil Tinkov
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #1996: DISTINCT fails with national character varying 

"Ludmil Tinkov" <ludmil(at)fyrex(dot)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

Next:From: Bruce MomjianDate: 2005-10-26 13:03:01
Subject: Re: BUG #1993: Adding/subtracting negative time intervals
Previous:From: Bruce MomjianDate: 2005-10-26 12:31:41
Subject: Re: BUG #1993: Adding/subtracting negative time intervals

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group