Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9t3W-00A8L2-Dx for pgsql-docs@arkaria.postgresql.org; Fri, 17 Oct 2025 22:36:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v9t3U-005xDc-Gq for pgsql-docs@arkaria.postgresql.org; Fri, 17 Oct 2025 22:36:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9t3U-005xDT-8H for pgsql-docs@lists.postgresql.org; Fri, 17 Oct 2025 22:36:11 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v9t3N-002MYN-0t for pgsql-docs@lists.postgresql.org; Fri, 17 Oct 2025 22:36:10 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-46b303f755aso23963495e9.1 for ; Fri, 17 Oct 2025 15:36:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1760740563; x=1761345363; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=Ub6wLTfFEnaHj1P8O23olyfsm0Cb6OodIUcLSZhYJT0=; b=OFiL5VwNATdlQNACCNreyazdLLVY408nPwxyMXhwJtpRC/cyYhF6z9Uau8sJyY+J8U +b5J64loKv5UgnzmwoaLcrtozZizNqreGLQBeRLVre1Q4hByBMwqmwLnrIK5uCRstXgT +UkU6p44WQhwlbn7H1/3Z9+M8+G/ogoYQYDHlhn+jcPhQtv+O4B3FkXo14pricmtmfar GZurhuhRL5caBZB5I5QhvzfoweXcq2froq/A4UBf4eWsu4oqvYxyVGUQlH57+5RZeOiv BRF2eVYQWyw6eLwFzKZFV+8ug8CRn3qESNcf3/tS0i24xGRNrmvx1QyIh1iMGyi+7J35 5Urg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760740563; x=1761345363; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Ub6wLTfFEnaHj1P8O23olyfsm0Cb6OodIUcLSZhYJT0=; b=DjpINOlONjdrxIOH3Ly0HYsi6IuZJJMplLWdb7QO3UBXqRPJ3UGshkL31cjDyCbRek ULU2whUkRrhi2O+BrKgS5V1Wo3dvQs7IET1mSMl6w/pzLadaxvP7C8fWKl5g/pxnfaR5 zwxjYWuT/eJbGTyhE1zq48EAb1xQoRLCGiLrOr75h1tGc2wconqouPTwVeaYGebNRWpJ Le9sSvn6s7rSiofnzOn4oqow/lLnGESZXwi+jqkxNKuTCHK2U8F7NZZxPqLS7nBxPUxB 1OZ2gkp3Wi+kUdGecGgHa0FXcmPRY91hiA6NIDFnlRwk3HtIQkwuT2GvgrvkrAJPPzH8 fJ0Q== X-Forwarded-Encrypted: i=1; AJvYcCX68zdP5UjDkuQy6t2tPGXykI4F5ehtTRNimu0ziQmfa/YChuffcZKhWcOrXG8Rgl1MjVwQ4ImNeuJM@lists.postgresql.org X-Gm-Message-State: AOJu0Yzdj5L2RBA9thjUOdonYQAm4eN4dE+kuiNcTO84+5oOpZ3lhPhz LoJwpgvjYjyrU74OoRU10MhY7b9sXqGhphDHXB/IIZHuQ9L7xjlltSvXSrPdhPMX0SE= X-Gm-Gg: ASbGncueXWU9SZNGf7EdWkQF4f51RrjFGl5rlovxtL/t1zfHnxsemtOEiPRAdEOK2l2 9AQUrlEGYJ8cKGLXXDaT0WNN9hEWQ/eV2S3tNc4rLRuPSrrt4AJB9WOm/lyRJc8y4ppFJuL+gB+ N8wm4rzGwSJOSLIOie9fRURZA9jnhjfQirL4Svo7u1S/bVFWmEA+Mjgatkcuk1wcQbGYx/BPRHF EzfbP7XQodYgZSFmNtPmz7rf5elbzg0yGCvRBXeyXTiAG/F5TdtBMMbxxP2PiZXlHMzqi1PUbqs 2DnuT+ptQBuYw7RD7FfgfIP1FpTUBUcmMw3vFx1rldTqmYDTiLzU5/MK+q/qyy+ZJEHGIE/9phK UY2tHLV/6jQbc+akJzoOQnCrX+M1LYKKtn3tXovtlkmSgv1sV8GwD5xM54wC+pAGoRM5QBM+El0 3daIv65SFQAe/Lx7jox5qZ1FnoFWvILhZO3JWHPHA= X-Google-Smtp-Source: AGHT+IH+h8YwGFTR17xGq6jePnDH+4MkBeEdn5LEA+DSu0+4jOShI56yK7wV+yg333SJpTXTFj3mRA== X-Received: by 2002:a05:600c:450a:b0:471:21:554a with SMTP id 5b1f17b1804b1-4711787c0c0mr36204095e9.13.1760740563574; Fri, 17 Oct 2025 15:36:03 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:825b:ae4:8fe6:d981:b98]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4710f29da7fsm54047275e9.9.2025.10.17.15.36.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 17 Oct 2025 15:36:03 -0700 (PDT) Message-ID: Subject: Re: BPCHAR description in 8.3. Character Types is misleading and incomplete From: Laurenz Albe To: Sergei Katkovsky Cc: Tom Lane , Jeff Davis , pgsql-docs@lists.postgresql.org Date: Sat, 18 Oct 2025 00:36:02 +0200 In-Reply-To: References: <176044409338.770.16064383081308443747@wrigleys.postgresql.org> <1307875.1760556576@sss.pgh.pa.us> <92151c4debb48bbbaed4db81c79d73c36f619858.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gRnJpLCAyMDI1LTEwLTE3IGF0IDE4OjE4ICswNDAwLCBTZXJnZWkgS2F0a292c2t5IHdyb3Rl Ogo+IE9uIEZyaSwgT2N0IDE3LCAyMDI1IGF0IDQ6NDnigK9QTSBMYXVyZW56IEFsYmUgPGxhdXJl bnouYWxiZUBjeWJlcnRlYy5hdD4gd3JvdGU6Cj4gCj4gPiAiYnBjaGFyIiBhbmQgInZhcmNoYXIi LCB3aGVuIHVzZWQgd2l0aG91dCB0eXBlIG1vZGlmaWVyLCBhcmUgYWN0dWFsbHkKPiA+IGlkZW50 aWNhbDoKPiA+IAo+ID4gU0VMRUNUIG9jdGV0X2xlbmd0aChCUENIQVIgJ3jCoMKgICcpLAo+ID4g wqDCoMKgwqDCoMKgwqAgb2N0ZXRfbGVuZ3RoKFZBUkNIQVIgJ3jCoMKgICcpLAo+ID4gwqDCoMKg wqDCoMKgwqAgb2N0ZXRfbGVuZ3RoKFRFWFQgJ3jCoMKgICcpOwo+ID4gCj4gPiDCoCBvY3RldF9s ZW5ndGgg4pSCIG9jdGV0X2xlbmd0aCDilIIgb2N0ZXRfbGVuZ3RoCj4gPiDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilarilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZDilZDilZDilZDilZDilarilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDilZDi lZDilZAKPiA+IMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoCA0IOKUgsKgwqDCoMKgwqDCoMKgwqDC oMKgwqAgNCDilILCoMKgwqDCoMKgwqDCoMKgwqDCoMKgIDQKPiA+IAo+ID4gVGhlIGJsYW5rLXRy aW1taW5nIG9ubHkgb2NjdXJzIHdoZW4gYSAiYnBjaGFyIiBpcyBjb252ZXJ0ZWQgdG8gInRleHQi LAo+ID4gZm9yIGV4YW1wbGUgd2hlbiB1c2VkIHdpdGggdGhlIGNvbmNhdGVuYXRpb24gb3BlcmF0 b3IuCj4gCj4gVW5mb3J0dW5hdGVseSwgQlBDSEFSIGFuZCBWQVJDSEFSIGFyZSBub3QgaWRlbnRp Y2FsIGluIG90aGVyIGNvbnRleHRzLgo+IFRoZSBzaXR1YXRpb24gaXMgbm90IHRoZSBzYW1lIGFz IHdpdGggQkNIQVIobiksIHdoaWNoIGlzIGp1c3QgYW4gYWxpYXMKPiBmb3IgQ0hBUihuKS4KPiBT RUxFQ1QgQlBDSEFSICd4JyA9IFZBUkNIQVIgJ3jCoMKgICcsIFZBUkNIQVIgJ3gnID0gQlBDSEFS ICd4wqDCoCAnLAo+IFZBUkNIQVIgJ3gnID0gVkFSQ0hBUiAneMKgwqAgJzsKPiB0cnVlIHRydWUg ZmFsc2UKPiBGb3IgY29tcGFyaXNvbiB3aXRoIEJQQ0hBUiB0cmFpbGluZyBibGFua3MgYXJlIGlu c2lnbmlmaWNhbnQsIGJ1dCB3aGVuCj4gd2UgaGF2ZSBWQVJDSEFSIG9uIGJvdGggc2lkZXMsIHRo ZXkgbWF0dGVyLgoKVGhleSBhcmUgc3RvcmVkIGlkZW50aWNhbGx5LCBidXQgYmVoYXZlIGRpZmZl cmVudGx5LCBzbyBJIHNob3VsZG4ndCBoYXZlCnNhaWQgdGhhdCB0aGV5ICphcmUqIGlkZW50aWNh bC4KClN0aWxsLCB0aGV5IGFsbCBhcmUgdmFyaWFibGUtbGVuZ3RoIHN0cmluZ3MsIHNvIHdlIGNv dWxkIGxpc3QgdGhlbSB0b2dldGhlci4KCkJ1dCBwZXJoYXBzIGl0IGlzIHJlYWxseSBiZXR0ZXIg dG8gbGVhdmUgdGhpbmdzIGFzIHRoZXkgYXJlIG5vdywgcGVyaGFwcwpyZXBsYWNpbmcgImJsYW5r LXRyaW1taW5nIiwgcGVyaGFwcyBhcyAidmFyaWFibGUtbGVuZ3RoIHN0cmluZyB0aGF0IGlnbm9y ZXMKdHJhaW5pbmcgYmxhbmtzIi4KCllvdXJzLApMYXVyZW56IEFsYmUK