Re: [BUGS] BUG #14885: mistake in sorting win1251 chars

On 11/02/2017 10:57 AM, k.daskalov.911@gmail.com wrote:
> 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:
> "АЙГЕР"
> "АИКО"
> "АЙКОН"
> 

Encoding only defines how different characters are encoded, it has
nothing to do with ordering - that's what collations are for. What
lc_collate value are you using?

See https://www.postgresql.org/docs/9.4/static/collation.html

cheers

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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