On 24.04.21 17:20, Jorge Silva wrote:
We have a database, which is encoded with LATIN1, and we are adding some tables in it to store xml files with the “xml” type. After creating the table and populating it, we use the xPath function to retrieve some data from the XML, but it seems to not work properly, because it returns:
As documented at <https://www.postgresql.org/docs/devel/datatype-xml.html#id-1.5.7.21.7>, xpath only works if the server encoding is UTF8.
