Markus Bertheau <twanger@bluetwanger.de> 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:
[tgl@rh1 tgl]$ cat ru_data
root
root
ÅÅçÅÝÅçÅ£î
ÅÅÅÇÅçÅ¥î
[tgl@rh1 tgl]$ sort -u ru_data
root
ÅÅçÅÝÅçÅ£î
ÅÅÅÇÅçÅ¥î
[tgl@rh1 tgl]$ LC_ALL=ru_RU.KOI8-R sort -u ru_data
root
ÅÅçÅÝÅçÅ£î
[tgl@rh1 tgl]$
(The above is on an RHL 8.0 platform.)
regards, tom lane