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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)
Дата
Msg-id 19321.1542906118@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)  (PG Bug reporting form <noreply@postgresql.org>)
Ответы RE: BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)  ("Calvo Arias, Francisco" <fcaa@tragsa.es>)
Список pgsql-bugs
Дерево обсуждения 
=?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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New sessions on a database to be dropped consume 100% cpu
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15517: JSONB_BUILD_ARRAY and JSON_BUILD_ARRAY omit XMLDeclaration (if present) from XML colums