Обсуждение: BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet

Поиск
Список
Период
Сортировка

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

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      16600
Logged by:          Dusan Djuric
Email address:      dusan.djuric@istratech.hr
PostgreSQL version: 12.3
Operating system:   Win 10 Pro (sys&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('šđč枊ĐČĆŽ')--"šđč枊ĐČĆŽ"    "šđč枊ĐČĆŽ"    "šđč枊ĐČĆŽ"


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

От
Tom Lane
Дата:
PG Bug reporting form <noreply@postgresql.org> writes:
> Postgres can't upper lower diacritic character of Croatina alfabet
> š,đ,č,ć,ž,Š,Đ,Č,Ć,Ž,

This isn't a Postgres issue; it's going to depend mainly on what
operating system locale settings (lc_collate and/or lc_ctype)
you've chosen for the database.

I'm not sure what the appropriate setting is on Windows, unfortunately.

            regards, tom lane