SQL Compare XML Output File Encoding
howarthcd
Posts: 70 Bronze 3
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
Comments
I've had a look and I don't currently see a way to set the encoding type. I've therefore logged a feature request for this (ref. SC-5232), which will get evaluated for inclusion in a future release.
Redgate Software