pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #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>
  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&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('šđč枊ĐČĆŽ')--"šđč枊ĐČĆŽ"	"šđč枊ĐČĆŽ"	"šđč枊ĐČĆŽ"



^ 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 22:07  Tom Lane <tgl@sss.pgh.pa.us>
  parent: PG Bug reporting form <noreply@postgresql.org>
  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