I have the following problem and need urgent solution:
- I have a tabel what I export with bcp to xml file with following command:
bcp "selectÃÂ ÃÂ * from mydb.dbo.myview FOR XML PATH ('Product'), ROOT ('Products'), ELEMENTS" queryout c:\myfolder\myxml.xml -T -r -t -w
The batch is running in order, but the file what I get is encoded in UTF-16. How can I export to be in UTF-8.
Thx for any help.
View Complete Post