Folding of case of identifiers
От | Niels Jespersen |
---|---|
Тема | Folding of case of identifiers |
Дата | |
Msg-id | d46916d0e9e84f66b158be52e5c4ad3a@dst.dk обсуждение исходный текст |
Ответы |
Re: Folding of case of identifiers
|
Список | pgsql-general |
Hello all According to https://www.postgresql.org/docs/current/sql-syntax-lexical.html, "Key words and unquoted identifiers are caseinsensitive." And "SQL identifiers and key words must begin with a letter (a-z, but also letters with diacritical marksand non-Latin letters) or an underscore (_). Subsequent characters in an identifier or key word can be letters, underscores,digits (0-9), or dollar signs ($)." So far so good. Non-latin letters are included, which I take to also include the danish letters æøå/ÆØÅ. However, name-folding is odd for these letters. Of these three create tables, the two first succeed, the last one does not(G and g is equivalent, Æ and æ is not). create table æblegrød (a int, køn text); create table ÆblegrØd (a int, køn text); create table ÆbleGrØd (a int, køn text); Can anyone explain the logic that rules this. Regards Niels Jespersen
В списке pgsql-general по дате отправления: