SQLTeam.com | Weblogs | Forums

BCP export XML from SQL Server - remove the UCS-2 LE BOM


#1

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?