• michael_alawneh (7/29/2014)


    None of the queries are XML. Simple selects just outputting as file.

    SET NOCOUNT ON

    SELECT Blah

    , Blah

    FROM dbo.tblBlah

    If it's a default for the UTF-8 format I'm sure there's a place to change it.

    I cannot recall such a setting, at least it is not in the Query Options.

    I have tried to reproduce this on my server by using combinations of language settings, server collations, column collation etc. but no luck.

    😎