It would be useful to be able to specify the encoding of the XML comparison output report when running SQL Compare 9 from the command line.
It appears that the encoding of the XML output report is always UTF-8, however we frequently generate reports that contain Windows-1252 characters.
To be able to convert such XML comparison reports to the SQL Server XML datatype I first have to replace the string:
<?xml version="1.0" encoding="utf-8"?>
...with:
<?xml version="1.0" encoding="Windows-1252"?>
...before the documents can be converted to the native SQL Server XML datatype or else an 'illegal character' error is raised.
Thanks
Chris
It appears that the encoding of the XML output report is always UTF-8, however we frequently generate reports that contain Windows-1252 characters.
To be able to convert such XML comparison reports to the SQL Server XML datatype I first have to replace the string:
<?xml version="1.0" encoding="utf-8"?>
...with:
<?xml version="1.0" encoding="Windows-1252"?>
...before the documents can be converted to the native SQL Server XML datatype or else an 'illegal character' error is raised.
Thanks
Chris