MIME-Version: 1.0
References: 
 <CAAGT0iKc1Fq=mmK99fMd8O+QGZfCAqzx3bOWBcci6fO8SjLGtQ@mail.gmail.com>
 <b31e1ee9-3bc9-43db-9f7c-ac0459c0570d@ewie.name>
In-Reply-To: <b31e1ee9-3bc9-43db-9f7c-ac0459c0570d@ewie.name>
From: Hoda Salim <hoda.s.salim@gmail.com>
Date: Mon, 2 Feb 2026 22:04:12 +0200
Message-ID: 
 <CAAGT0i+SrExi4LVf-gQ4t9XY724pVRxEvOZft4B0uUs-gDuYHA@mail.gmail.com>
Subject: Re: [PATCH] docs: document N'...' national character string literal
 syntax
To: Erik Wienhold <ewie@ewie.name>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="0000000000006b477f0649dcd471"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAGT0i%2BSrExi4LVf-gQ4t9XY724pVRxEvOZft4B0uUs-gDuYHA%40mail.gmail.com>
Precedence: bulk

--0000000000006b477f0649dcd471
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

> nchar is an alias of bpchar.  There's no cast to char behind the scenes
> since that would truncate the string:
>
>         select n'foo', 'foo'::character;
>          bpchar | bpchar
>         --------+--------
>          foo    | f
>         (1 row)

Thank you for catching this! I verified the behavior and updated the
documentation to correctly state that N'...' is equivalent to a bpchar
literal.

> Should we also mention the nchar alias in [4]?
> [4] https://www.postgresql.org/docs/current/datatype-character.html

I'm happy to add that in a v3 if you think it belongs in this patch.
I wasn't sure if it would be preferred separately or together.

Updated patch attached.

--
Hoda Salim


On Mon, Feb 2, 2026 at 7:09=E2=80=AFPM Erik Wienhold <ewie@ewie.name> wrote=
:
>
> On 2026-02-02 16:05 +0100, Hoda Salim wrote:
> > This patch documents the N'...' national character string literal
> > syntax, which has been supported by PostgreSQL but was previously
> > undocumented.
> >
> > The documentation explains:
> > - What the syntax is (N'hello')
> > - What the SQL standard specifies (implementation-defined national
> > character set)
> > - What PostgreSQL actually does (treats it as a cast to character type)
> > - Why it exists (compatibility with SQL migrated from other databases)
> >
> > I verified the documentation builds without errors.
>
> +1
>
> I brought up the missing documentation before [1], but wasn't sure at
> the time if Postgres conforms to the SQL standard (mainly because of
> [2]).  Now I see that [3] already claims to support national character
> (F421).  That entry was commented with "syntax accepted" until commit
> 35223af0579.  I read that as "fully supported" now.
>
> > +     <productname>PostgreSQL</productname> does not implement a separa=
te
> > +     national character set; it treats <literal>N'...'</literal> as
> > +     equivalent to a regular string constant cast to the
> > +     <type>character</type> type, that is, <literal>'...'::character</=
literal>,
> > +     using the database's character set.
>
> nchar is an alias of bpchar.  There's no cast to char behind the scenes
> since that would truncate the string:
>
>         select n'foo', 'foo'::character;
>          bpchar | bpchar
>         --------+--------
>          foo    | f
>         (1 row)
>
> Should we also mention the nchar alias in [4]?
>
> [1] https://www.postgresql.org/message-id/om3g7p7u3ztlrdp4tfswgulavljgn2f=
e6u2agk34mrr65dffuu%40cpzlzuv6flko
> [2] https://www.postgresql.org/message-id/1275895438.1849.1.camel@fsopti5=
79.F-Secure.com
> [3] https://www.postgresql.org/docs/current/features-sql-standard.html
> [4] https://www.postgresql.org/docs/current/datatype-character.html
>
> --
> Erik Wienhold

--0000000000006b477f0649dcd471
Content-Type: application/octet-stream;
	name="v2-0001-docs-document-N-.-national-character-string-liter.patch"
Content-Disposition: attachment;
	filename="v2-0001-docs-document-N-.-national-character-string-liter.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_ml5lefmb0>
X-Attachment-Id: f_ml5lefmb0

RnJvbSA4MjZmNDY5ZmU2ODFiOTg3NTQzN2JmYjdlM2M4MDVjMDkyY2Y4YjBhIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBIb2RhU2FsaW0gPGhvZGEucy5zYWxpbUBnbWFpbC5jb20+CkRh
dGU6IE1vbiwgMiBGZWIgMjAyNiAxNDo1NDozNyArMDAwMApTdWJqZWN0OiBbUEFUQ0ggdjJdIGRv
Y3M6IGRvY3VtZW50IE4nLi4uJyBuYXRpb25hbCBjaGFyYWN0ZXIgc3RyaW5nIGxpdGVyYWwKIHN5
bnRheAoKRG9jdW1lbnQgdGhlIE4nLi4uJyBzdHJpbmcgbGl0ZXJhbCBzeW50YXggaW4gdGhlIExl
eGljYWwgU3RydWN0dXJlCnNlY3Rpb24gb2YgdGhlIGRvY3VtZW50YXRpb24uIFRoaXMgU1FMLXN0
YW5kYXJkIHN5bnRheCBmb3IgbmF0aW9uYWwKY2hhcmFjdGVyIHN0cmluZyBsaXRlcmFscyBoYXMg
YmVlbiBzdXBwb3J0ZWQgYnkgUG9zdGdyZVNRTCBidXQgd2FzCnByZXZpb3VzbHkgdW5kb2N1bWVu
dGVkLgoKVGhlIGRvY3VtZW50YXRpb24gZXhwbGFpbnMgdGhhdCB3aGlsZSB0aGUgU1FMIHN0YW5k
YXJkIHNwZWNpZmllcyB0aGlzCnN5bnRheCBmb3IgYW4gaW1wbGVtZW50YXRpb24tZGVmaW5lZCBu
YXRpb25hbCBjaGFyYWN0ZXIgc2V0LCBQb3N0Z3JlU1FMCnRyZWF0cyBOJy4uLicgYXMgZXF1aXZh
bGVudCB0byBhIGJwY2hhciAoYmxhbmstcGFkZGVkIGNoYXJhY3RlcikgdHlwZQpsaXRlcmFsLCBz
aW5jZSBQb3N0Z3JlU1FMIHVzZXMgYSBzaW5nbGUgY2hhcmFjdGVyIHNldCBmb3IgYWxsIHN0cmlu
Zwp0eXBlcy4KLS0tCiBkb2Mvc3JjL3NnbWwvc3ludGF4LnNnbWwgfCA0MSArKysrKysrKysrKysr
KysrKysrKysrKysrKysrKysrKysrKysrKysrCiAxIGZpbGUgY2hhbmdlZCwgNDEgaW5zZXJ0aW9u
cygrKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9zeW50YXguc2dtbCBiL2RvYy9zcmMvc2dt
bC9zeW50YXguc2dtbAppbmRleCA2NzQ4Mjk5Njg2MS4uYjU5ZTcxYTI2NjQgMTAwNjQ0Ci0tLSBh
L2RvYy9zcmMvc2dtbC9zeW50YXguc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvc3ludGF4LnNnbWwK
QEAgLTU5MCw2ICs1OTAsNDcgQEAgJGZ1bmN0aW9uJAogICAgIDwvcGFyYT4KICAgIDwvc2VjdDM+
CgorICAgPHNlY3QzIGlkPSJzcWwtc3ludGF4LXN0cmluZ3MtbmF0aW9uYWwiPgorICAgIDx0aXRs
ZT5OYXRpb25hbCBDaGFyYWN0ZXIgU3RyaW5nIENvbnN0YW50czwvdGl0bGU+CisKKyAgICA8aW5k
ZXh0ZXJtIHpvbmU9InNxbC1zeW50YXgtc3RyaW5ncy1uYXRpb25hbCI+CisgICAgIDxwcmltYXJ5
Pm5hdGlvbmFsIGNoYXJhY3RlcjwvcHJpbWFyeT4KKyAgICAgPHNlY29uZGFyeT5zdHJpbmcgY29u
c3RhbnQ8L3NlY29uZGFyeT4KKyAgICA8L2luZGV4dGVybT4KKworICAgIDxwYXJhPgorICAgICA8
cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwvcHJvZHVjdG5hbWU+IGFjY2VwdHMgc3RyaW5nIGNvbnN0
YW50cworICAgICB3aXRoIGEgbGVhZGluZyA8bGl0ZXJhbD5OPC9saXRlcmFsPiAodXBwZXIgb3Ig
bG93ZXIgY2FzZSkKKyAgICAgaW1tZWRpYXRlbHkgYmVmb3JlIHRoZSBvcGVuaW5nIHNpbmdsZSBx
dW90ZSwgZm9yCisgICAgIGV4YW1wbGUgPGxpdGVyYWw+TidoZWxsbyc8L2xpdGVyYWw+LiAgVGhp
cyBzeW50YXggaXMgc3BlY2lmaWVkIGJ5CisgICAgIHRoZSA8YWNyb255bT5TUUw8L2Fjcm9ueW0+
IHN0YW5kYXJkIGZvciBpZGVudGlmeWluZyBzdHJpbmcKKyAgICAgbGl0ZXJhbHMgb2YgPHF1b3Rl
Pm5hdGlvbmFsIGNoYXJhY3RlcjwvcXVvdGU+IHR5cGVzCisgICAgICg8dHlwZT5OQ0hBUjwvdHlw
ZT4gYW5kIDx0eXBlPk5DSEFSIFZBUllJTkc8L3R5cGU+KS4KKyAgICA8L3BhcmE+CisKKyAgICA8
cGFyYT4KKyAgICAgIFRoZSA8YWNyb255bT5TUUw8L2Fjcm9ueW0+IHN0YW5kYXJkIHNwZWNpZmll
cyB0aGF0IHN0cmluZ3Mgd3JpdHRlbgorICAgICAgd2l0aCB0aGlzIHN5bnRheCBzaG91bGQgdXNl
IGFuIDxxdW90ZT5pbXBsZW1lbnRhdGlvbi1kZWZpbmVkCisgICAgICBuYXRpb25hbCBjaGFyYWN0
ZXIgc2V0PC9xdW90ZT4uCisgICAgICA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwvcHJvZHVjdG5h
bWU+IGRvZXMgbm90IGltcGxlbWVudCBhIHNlcGFyYXRlCisgICAgICBuYXRpb25hbCBjaGFyYWN0
ZXIgc2V0OyBpdCB0cmVhdHMgPGxpdGVyYWw+TicuLi4nPC9saXRlcmFsPiBhcworICAgICAgZXF1
aXZhbGVudCB0byBhIHN0cmluZyBjb25zdGFudCBvZiB0eXBlIDx0eXBlPmJwY2hhcjwvdHlwZT4K
KyAgICAgIChibGFuay1wYWRkZWQgY2hhcmFjdGVyKSwgZm9yIGV4YW1wbGUgPGxpdGVyYWw+Tido
ZWxsbyc8L2xpdGVyYWw+CisgICAgICBoYXMgdGhlIHNhbWUgdHlwZSBhbmQgdmFsdWUgYXMgPGxp
dGVyYWw+J2hlbGxvJzo6YnBjaGFyPC9saXRlcmFsPi4KKyAgICAgIE5vdGUgdGhhdCB0cmFpbGlu
ZyBzcGFjZXMgYXJlIHNlbWFudGljYWxseSBpbnNpZ25pZmljYW50CisgICAgICBpbiA8dHlwZT5i
cGNoYXI8L3R5cGU+IHZhbHVlcy4KKyAgICA8L3BhcmE+CisKKyAgICA8cGFyYT4KKyAgICAgVGhp
cyBzeW50YXggaXMgYWNjZXB0ZWQgcHJpbWFyaWx5IGZvciBjb21wYXRpYmlsaXR5IHdpdGggU1FM
CisgICAgIG1pZ3JhdGVkIGZyb20gb3RoZXIgZGF0YWJhc2Ugc3lzdGVtcy4gIFNpbmNlCisgICAg
IDxwcm9kdWN0bmFtZT5Qb3N0Z3JlU1FMPC9wcm9kdWN0bmFtZT4gdXNlcyBhIHNpbmdsZSBjaGFy
YWN0ZXIgc2V0CisgICAgIGZvciBhbGwgc3RyaW5nIHR5cGVzIChkZXRlcm1pbmVkIGJ5IHRoZSBk
YXRhYmFzZSBlbmNvZGluZyksCisgICAgIHRoZXJlIGlzIHR5cGljYWxseSBubyBhZHZhbnRhZ2Ug
dG8gdXNpbmcKKyAgICAgPGxpdGVyYWw+TicuLi4nPC9saXRlcmFsPiBvdmVyIHJlZ3VsYXIgc3Ry
aW5nIGNvbnN0YW50cy4KKyAgICA8L3BhcmE+CisgICA8L3NlY3QzPgorCiAgICA8c2VjdDMgaWQ9
InNxbC1zeW50YXgtYml0LXN0cmluZ3MiPgogICAgIDx0aXRsZT5CaXQtU3RyaW5nIENvbnN0YW50
czwvdGl0bGU+CgotLQoyLjQzLjAK
--0000000000006b477f0649dcd471--