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.