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

From k.daskalov.911@gmail.com
Subject [BUGS] BUG #14885: mistake in sorting win1251 chars
Date
Msg-id 20171102095719.17188.59150@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14885: mistake in sorting win1251 chars  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: [BUGS] BUG #14885: mistake in sorting win1251 chars  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14885
Logged by:          Kalin Daskalov
Email address:      k.daskalov.911@gmail.com
PostgreSQL version: 9.4.4
Operating system:   windows 7 64 bit
Description:

I'm using ORDER BY <character varying field> containing win-1251 symbols.
No matter whether the encoding is WIN1251 or UTF8.
I try it on different versions of PostgreSQL - the result is the same.
There is a mistake in sorted values for symbols "и" (и) and "й"
(й) - capital letters too.
Here is a small example:
"АЙГЕР"
"АИКО"
"АЙКОН"



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Oleksandr Shulgin
Date:
Subject: Re: [BUGS] Creating a table by loading a sql file.
Next
From: Tomas Vondra
Date:
Subject: Re: [BUGS] BUG #14884: Encoding Error