Re: [BUGS] BUG #14885: mistake in sorting win1251 chars - Mailing list pgsql-bugs

On Thu, Nov 2, 2017 at 10:57 AM,  <k.daskalov.911@gmail.com> wrote:
> Here is a small example:
> "АЙГЕР"
> "АИКО"
> "АЙКОН"

Are you sure it's sorting badly? In some collations some letters sort
equally, you should try:

"АИКО"
"АЙКОН"
and
"АИКОH"
"АЙКО"

as "И" may be sorting in the same place as "Й" and it is deciding by the tails.

It happens in spanish with the tildes ( a and à sort in the same
place, so unless they are the only difference order depends on aht is
around:
test=> select * from ( values ('a'),('à'),('ay'),('àx'),('za'),('zà')
) x order by 1;
 column1
---------
 a
 à
 àx
 ay
 za
 zà
(6 rows)
)

Doing something like this with your alphabet may shed some light on the issue.

(note, this was done with locale en_US.utf-8 )

Francisco Olarte.