Jorge Silva <jorge(dot)silva93(at)gmail(dot)com> writes:
> The characters that it is not recognizing are both “ç” and “ã” because I think they are encoded differently in latin1 and utf-8. Is it possible to somehow use the xPath function with special characters in the XML and in a database which is not encoded with utf-8?
I don't have a lot of expertise in this area, but I think you need
an explicit encoding indicator in the xml header, a la
<?xml encoding="latin1"?> ...
On the whole, the xml type is definitely easier to use with database
encoding set to utf8. I think you'll be paying for encoding conversion
every time we interact with libxml, for instance.
regards, tom lane