Thread: In unquoted identifiers,only single-byte characters are always folded to lower case
In unquoted identifiers,only single-byte characters are always folded to lower case
From
PG Doc comments form
Date:
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-syntax-lexical.html Description: Last paragraph on "4.1.1. Identifiers and Key Words" in the documentation states: 1.- "[...] unquoted names are always folded to lower case" 2.- "If you want to write portable applications you are advised to always quote a particular name or never quote it" As said in response to bug #15516 (Identifier not quoted with uppercase letter (spanish Ñ) doesn't get transformed to lowercase (ñ)) on pgsql-bugs: "PG's downcasing transform is only applied to single-byte characters. So Ñ could be transformed in LATIN1 encoding, but not UTF8." Given that, that paragraph should clarify this situation by: 1.- replacing "always folded to lower case" with "always folded to lower case, except for multi-byte characters". 2.- adding another example about this. For instance, "But identifier AÑO (using multi-byte character Ñ, Unicode U+00D1) is folded to aÑo." 3.- removing "or never quote it". Regards, Paco Calvo.