pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet
2+ messages / 2 participants
[nested] [flat]
* BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet
@ 2020-08-28 17:58 PG Bug reporting form <noreply@postgresql.org>
2020-08-28 22:07 ` Re: BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2020-08-28 17:58 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: dusan.djuric@istratech.hr
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('šđč枊ĐČĆŽ')--"šđč枊ĐČĆŽ" "šđč枊ĐČĆŽ" "šđč枊ĐČĆŽ"
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet
2020-08-28 17:58 BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet PG Bug reporting form <noreply@postgresql.org>
@ 2020-08-28 22:07 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2020-08-28 22:07 UTC (permalink / raw)
To: dusan.djuric@istratech.hr; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-08-28 22:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-28 17:58 BUG #16600: Postgres can't upper lower diacritic character of Croatina alfabet PG Bug reporting form <noreply@postgresql.org>
2020-08-28 22:07 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox