What are the challenges you face when working across database platforms? Take the survey

SQL Compare XML Output File Encoding

howarthcdhowarthcd Posts: 70 Bronze 3
edited August 22, 2011 8:43AM in SQL Compare Previous Versions
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"?>


<?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.



  • Options
    Thanks for your post.

    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.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.