Thank you very much for your clarification, Tom. (Also, I'm very sorry for not ending and signing my previous message
properly.Shame on me, having being Thanksgivig Day!)
I think I'll submit a correction mentioning that ("PG's downcasing transform is only applied to single-byte
characters")for last paragraph on "4.1.1. Identifiers and Key Words" in the documentation which states:
- "[...] unquoted names are always folded to lower case"
- "If you want to write portable applications you are advised to always quote a particular name or never quote it"
Regards,
Paco Calvo
-----Mensaje original-----
De: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Enviado el: jueves, 22 de noviembre de 2018 18:02
Para: Calvo Arias, Francisco <fcaa@tragsa.es>
CC: pgsql-bugs@lists.postgresql.org
Asunto: Re: BUG #15516: Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase
(ñ)
=?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
tochange soon.
regards, tom lane
**********************************************************************************************
El consumo de papel es perjudicial para el medio ambiente. Por favor, téngalo en cuenta antes de imprimir este mensaje.
AVISOLEGAL: Este mensaje y sus anexos pueden contener información confidencial o legalmente protegida. Está dirigido
únicamentea la persona o entidad indicada como destinatarios del mensaje. Si este mensaje le hubiera llegado por error,
porfavor elimínelo sin revisarlo ni reenviarlo y notifíquelo inmediatamente al remitente.
**********************************************************************************************
