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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fcaa(at)tragsa(dot)es
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)
Date: 2018-11-22 17:01:58
Message-ID: 19321.1542906118@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-11-22 18:40:08 BUG #15517: JSONB_BUILD_ARRAY and JSON_BUILD_ARRAY omit XML Declaration (if present) from XML colums
Previous Message Tom Lane 2018-11-22 16:42:14 Re: New sessions on a database to be dropped consume 100% cpu