On 25.04.21 10:44, Holger Jakobs wrote:
The point is that the XML standard dictates that every document without an explicit encoding, must be encodied in UTF-8. So, whenever you want to use a different encoding, this has to be stated in the XML header, as indicated in Tom Lane's answer.
If you are transmitting an XML datum from the client to the server in the text protocol, then the encoding declaration is ignored. See this documentation:
https://www.postgresql.org/docs/devel/datatype-xml.html#id-1.5.7.21.7
