Markus Bertheau <[EMAIL PROTECTED]> writes:
> Do the following in an installation initdb'd in ru_RU.KOI8-R (It doesn't
> happen if you initdb'd with UTF-8).
If this is a bug, it's a bug in the ru_RU.KOI8-R locale definition.
You can prove that the locale considers the strings equal without
Postgres at all:
[EMAIL PROTECTED] tgl]$ cat ru_data
root
root
ÅœÅçÅÝÅçÅ£îŒ
ÅœÅÅÇÅçÅ¥î‹
[EMAIL PROTECTED] tgl]$ sort -u ru_data
root
ÅœÅçÅÝÅçÅ£îŒ
ÅœÅÅÇÅçÅ¥î‹
[EMAIL PROTECTED] tgl]$ LC_ALL=ru_RU.KOI8-R sort -u ru_data
root
ÅœÅçÅÝÅçÅ£îŒ
[EMAIL PROTECTED] tgl]$
(The above is on an RHL 8.0 platform.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
