Windows-1252 and XML Parse Error

Discussion created by alqemist on Aug 15, 2017
Latest reply on Aug 16, 2017 by beverly

We use Fx.php to connect FM files to php web pages. I ran into a problem today with a record containing a malformed URL which caused fatal XML parsing error in the web page.  Debugging using the FMRESULTSET.XML request revealed the error as it failed when trying to process the field containing the URL.


In FileMaker the URL text appeared perfectly normal but I suspect it had been copy/pasted from a Windows application encoded as Windows-1252.

Is there a solution for trapping and/or transforming content in a case like this ?