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ààxayzazà
(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.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs