Through SQL SERVER and using BCP I have to export to a folder a set of information in XML format.
At this point I am using the SQL command:
SET @ComandoDOS = 'bcp "select Response from ##_tmpTabelaExportResponseXML" queryout "' + @DirectoriaFicheirosResponse + '\' + @NomeFicheiro + '" -w -T -S' + @@servername
The content of the information is all correct, I'm just having problems in the generated encoding. The output generated always comes with the encoding UCS-2 LE BOM.
I need to change the encoding to another qualuqer that does not contain LE BOM. How can I export information in XML format without LE BOM encoding?