MIME-Version: 1.0
From: Hoda Salim <hoda.s.salim@gmail.com>
Date: Mon, 2 Feb 2026 17:05:03 +0200
Message-ID: 
 <CAAGT0iKc1Fq=mmK99fMd8O+QGZfCAqzx3bOWBcci6fO8SjLGtQ@mail.gmail.com>
Subject: [PATCH] docs: document N'...' national character string literal
 syntax
To: pgsql-docs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="0000000000008e93a80649d8a609"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAGT0iKc1Fq%3DmmK99fMd8O%2BQGZfCAqzx3bOWBcci6fO8SjLGtQ%40mail.gmail.com>
Precedence: bulk

--0000000000008e93a80649d8a609
Content-Type: text/plain; charset="UTF-8"

Hi,

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.

-- 
Hoda Salim

--0000000000008e93a80649d8a609
Content-Type: application/octet-stream;
	name="0001-docs-document-N-national-character-string-literal.patch"
Content-Disposition: attachment;
	filename="0001-docs-document-N-national-character-string-literal.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_ml5arot90>
X-Attachment-Id: f_ml5arot90

RnJvbSBhZWNiOWU2ZmRhY2I5MmNjOTYwOTlhZmQ4OWFkMGE2MjhiOTdlOTE2IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBIb2RhU2FsaW0gPGhvZGEucy5zYWxpbUBnbWFpbC5jb20+CkRh
dGU6IE1vbiwgMiBGZWIgMjAyNiAxNDo1NDozNyArMDAwMApTdWJqZWN0OiBbUEFUQ0hdIGRvY3M6
IGRvY3VtZW50IE4nLi4uJyBuYXRpb25hbCBjaGFyYWN0ZXIgc3RyaW5nIGxpdGVyYWwKIHN5bnRh
eAoKRG9jdW1lbnQgdGhlIE4nLi4uJyBzdHJpbmcgbGl0ZXJhbCBzeW50YXggaW4gdGhlIExleGlj
YWwgU3RydWN0dXJlCnNlY3Rpb24gb2YgdGhlIGRvY3VtZW50YXRpb24uIFRoaXMgU1FMLXN0YW5k
YXJkIHN5bnRheCBmb3IgbmF0aW9uYWwKY2hhcmFjdGVyIHN0cmluZyBsaXRlcmFscyBoYXMgYmVl
biBzdXBwb3J0ZWQgYnkgUG9zdGdyZVNRTCBidXQgd2FzCnByZXZpb3VzbHkgdW5kb2N1bWVudGVk
LgoKVGhlIGRvY3VtZW50YXRpb24gZXhwbGFpbnMgdGhhdCB3aGlsZSB0aGUgU1FMIHN0YW5kYXJk
IHNwZWNpZmllcyB0aGlzCnN5bnRheCBmb3IgYW4gaW1wbGVtZW50YXRpb24tZGVmaW5lZCBuYXRp
b25hbCBjaGFyYWN0ZXIgc2V0LCBQb3N0Z3JlU1FMCnRyZWF0cyBOJy4uLicgYXMgZXF1aXZhbGVu
dCB0byBhIGNhc3QgdG8gdGhlIGNoYXJhY3RlciB0eXBlIHVzaW5nIHRoZQpkYXRhYmFzZSdzIGVu
Y29kaW5nLCBzaW5jZSBQb3N0Z3JlU1FMIHVzZXMgYSBzaW5nbGUgY2hhcmFjdGVyIHNldCBmb3IK
YWxsIHN0cmluZyB0eXBlcy4KLS0tCiBkb2Mvc3JjL3NnbWwvc3ludGF4LnNnbWwgfCA0MyArKysr
KysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrCiAxIGZpbGUgY2hhbmdlZCwgNDMg
aW5zZXJ0aW9ucygrKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9zeW50YXguc2dtbCBiL2Rv
Yy9zcmMvc2dtbC9zeW50YXguc2dtbAppbmRleCA2NzQ4Mjk5Njg2MS4uODVlMWY5YzQzNmYgMTAw
NjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9zeW50YXguc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvc3lu
dGF4LnNnbWwKQEAgLTU5MCw2ICs1OTAsNDkgQEAgJGZ1bmN0aW9uJAogICAgIDwvcGFyYT4KICAg
IDwvc2VjdDM+CgorICAgPHNlY3QzIGlkPSJzcWwtc3ludGF4LXN0cmluZ3MtbmF0aW9uYWwiPgor
ICAgIDx0aXRsZT5OYXRpb25hbCBDaGFyYWN0ZXIgU3RyaW5nIENvbnN0YW50czwvdGl0bGU+CisK
KyAgICA8aW5kZXh0ZXJtIHpvbmU9InNxbC1zeW50YXgtc3RyaW5ncy1uYXRpb25hbCI+CisgICAg
IDxwcmltYXJ5Pm5hdGlvbmFsIGNoYXJhY3RlcjwvcHJpbWFyeT4KKyAgICAgPHNlY29uZGFyeT5z
dHJpbmcgY29uc3RhbnQ8L3NlY29uZGFyeT4KKyAgICA8L2luZGV4dGVybT4KKworICAgIDxwYXJh
PgorICAgICA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwvcHJvZHVjdG5hbWU+IGFjY2VwdHMgc3Ry
aW5nIGNvbnN0YW50cworICAgICB3aXRoIGEgbGVhZGluZyA8bGl0ZXJhbD5OPC9saXRlcmFsPiAo
dXBwZXIgb3IgbG93ZXIgY2FzZSkKKyAgICAgaW1tZWRpYXRlbHkgYmVmb3JlIHRoZSBvcGVuaW5n
IHNpbmdsZSBxdW90ZSwgZm9yCisgICAgIGV4YW1wbGUgPGxpdGVyYWw+TidoZWxsbyc8L2xpdGVy
YWw+LiAgVGhpcyBzeW50YXggaXMgc3BlY2lmaWVkIGJ5CisgICAgIHRoZSA8YWNyb255bT5TUUw8
L2Fjcm9ueW0+IHN0YW5kYXJkIGZvciBpZGVudGlmeWluZyBzdHJpbmcKKyAgICAgbGl0ZXJhbHMg
b2YgPHF1b3RlPm5hdGlvbmFsIGNoYXJhY3RlcjwvcXVvdGU+IHR5cGVzCisgICAgICg8dHlwZT5O
Q0hBUjwvdHlwZT4gYW5kIDx0eXBlPk5DSEFSIFZBUllJTkc8L3R5cGU+KS4KKyAgICA8L3BhcmE+
CisKKyAgICA8cGFyYT4KKyAgICAgVGhlIDxhY3JvbnltPlNRTDwvYWNyb255bT4gc3RhbmRhcmQg
c3BlY2lmaWVzIHRoYXQgc3RyaW5ncyB3cml0dGVuCisgICAgIHdpdGggdGhpcyBzeW50YXggc2hv
dWxkIHVzZSBhbiA8cXVvdGU+aW1wbGVtZW50YXRpb24tZGVmaW5lZAorICAgICBuYXRpb25hbCBj
aGFyYWN0ZXIgc2V0PC9xdW90ZT4uCisgICAgIDxwcm9kdWN0bmFtZT5Qb3N0Z3JlU1FMPC9wcm9k
dWN0bmFtZT4gZG9lcyBub3QgaW1wbGVtZW50IGEgc2VwYXJhdGUKKyAgICAgbmF0aW9uYWwgY2hh
cmFjdGVyIHNldDsgaXQgdHJlYXRzIDxsaXRlcmFsPk4nLi4uJzwvbGl0ZXJhbD4gYXMKKyAgICAg
ZXF1aXZhbGVudCB0byBhIHJlZ3VsYXIgc3RyaW5nIGNvbnN0YW50IGNhc3QgdG8gdGhlCisgICAg
IDx0eXBlPmNoYXJhY3RlcjwvdHlwZT4gdHlwZSwgdGhhdCBpcywgPGxpdGVyYWw+Jy4uLic6OmNo
YXJhY3RlcjwvbGl0ZXJhbD4sCisgICAgIHVzaW5nIHRoZSBkYXRhYmFzZSdzIGNoYXJhY3RlciBz
ZXQuCisgICAgIFNpbmNlIDx0eXBlPmNoYXJhY3RlcjwvdHlwZT4gd2l0aG91dCBhIGxlbmd0aCBz
cGVjaWZpZXIgYWNjZXB0cyBzdHJpbmdzCisgICAgIG9mIGFueSBzaXplLCB0aGUgcmVzdWx0IGlz
IGEgdmFsdWUgb2YgdHlwZSA8dHlwZT5jaGFyYWN0ZXI8L3R5cGU+CisgICAgIHdpdGggdGhlIGxl
bmd0aCBvZiB0aGUgZ2l2ZW4gc3RyaW5nLiAgTm90ZSB0aGF0IHRyYWlsaW5nIHNwYWNlcworICAg
ICBhcmUgc2VtYW50aWNhbGx5IGluc2lnbmlmaWNhbnQgaW4gPHR5cGU+Y2hhcmFjdGVyPC90eXBl
PiB2YWx1ZXMuCisgICAgPC9wYXJhPgorCisgICAgPHBhcmE+CisgICAgIFRoaXMgc3ludGF4IGlz
IGFjY2VwdGVkIHByaW1hcmlseSBmb3IgY29tcGF0aWJpbGl0eSB3aXRoIFNRTAorICAgICBtaWdy
YXRlZCBmcm9tIG90aGVyIGRhdGFiYXNlIHN5c3RlbXMuICBTaW5jZQorICAgICA8cHJvZHVjdG5h
bWU+UG9zdGdyZVNRTDwvcHJvZHVjdG5hbWU+IHVzZXMgYSBzaW5nbGUgY2hhcmFjdGVyIHNldAor
ICAgICBmb3IgYWxsIHN0cmluZyB0eXBlcyAoZGV0ZXJtaW5lZCBieSB0aGUgZGF0YWJhc2UgZW5j
b2RpbmcpLAorICAgICB0aGVyZSBpcyB0eXBpY2FsbHkgbm8gYWR2YW50YWdlIHRvIHVzaW5nCisg
ICAgIDxsaXRlcmFsPk4nLi4uJzwvbGl0ZXJhbD4gb3ZlciByZWd1bGFyIHN0cmluZyBjb25zdGFu
dHMuCisgICAgPC9wYXJhPgorICAgPC9zZWN0Mz4KKwogICAgPHNlY3QzIGlkPSJzcWwtc3ludGF4
LWJpdC1zdHJpbmdzIj4KICAgICA8dGl0bGU+Qml0LVN0cmluZyBDb25zdGFudHM8L3RpdGxlPgoK
LS0KMi40My4wCg==
--0000000000008e93a80649d8a609--