BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: dusan(dot)djuric(at)istratech(dot)hr
Subject: BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet
Date: 2020-08-28 17:58:21
Message-ID: 16600-e12cfc7b2b9ed806@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16600
Logged by: Dusan Djuric
Email address: dusan(dot)djuric(at)istratech(dot)hr
PostgreSQL version: 12.3
Operating system: Win 10 Pro (sys&amp;input locale hr;Croatian cp:852)
Description:

Postgres can't upper lower diacritic character of Croatina alfabet
š,đ,č,ć,ž,Š,Đ,Č,Ć,Ž,

Test case:
SHOW SERVER_ENCODING; --UTF8
SHOW CLIENT_ENCODING; --UNICODE

SELECT upper('a') = upper('a') -- true
SELECT upper('A') = upper('a') -- true
SELECT upper('a') = upper('A') -- true
SELECT upper('A') = upper('A') -- true
SELECT upper('a') = 'A' --

SELECT upper('š') = upper('š') -- true
SELECT upper('Š') = upper('š') -- false
SELECT upper('š') = upper('Š') -- false
SELECT upper('Š') = upper('Š') -- true
SELECT upper('š') = 'Š' -- false

SELECT
'šđč枊ĐČĆŽ',upper('šđč枊ĐČĆŽ'),lower('šđč枊ĐČĆŽ')--"šđč枊ĐČĆŽ" "šđč枊ĐČĆŽ" "šđč枊ĐČĆŽ"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-08-28 19:04:02 BUG #16601: Restore Issue
Previous Message Magnus Hagander 2020-08-28 17:25:47 Re: Pg_restore failed