Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)
Date
Msg-id 19321.1542906118@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)  ("Calvo Arias, Francisco" <fcaa@tragsa.es>)
List pgsql-bugs
Tree view 
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> When using an identifier not quoted which includes an uppercase letter
> (Spanish Ñ, Unicode U+00D1), it doesn't get transformed to lowercase (ñ,
> Unicode U+00F1) as expected.

PG's downcasing transform is only applied to single-byte characters.
So Ñ could be transformed in LATIN1 encoding, but not UTF8.  There are
various practical reasons why this is unlikely to change soon.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: New sessions on a database to be dropped consume 100% cpu
Next
From: PG Bug reporting form
Date:
Subject: BUG #15517: JSONB_BUILD_ARRAY and JSON_BUILD_ARRAY omit XMLDeclaration (if present) from XML colums