Post reply

Encoding of FOR XML results

  • April 21, 2014 at 4:11 am

    #74767

    What is the encoding of the XML resulting from a FOR XML query?

    Can I force an encoding?

  • April 21, 2014 at 5:14 am

    #1707403

    Check out Using XML Data Types on technet

    😎

  • April 21, 2014 at 6:10 am

    #1707415

    I'm sorry but I failed to get an answer from the provided link.

    I have a query that evaluates into an XML document.

    I want to read it with SqlCommand.ExecuteXmlReader.

    But the accented characters are no right. Not even when I run the query in a Visual Studio 2013 query window and open the XML result.

  • April 21, 2014 at 6:38 am

    #1707427

    Instead of trying to describe the issue you're struggling with just verbally, it would be more helpful if you could post some sample data so we have something to test against.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • April 21, 2014 at 6:48 am

    #1707429

    paulo.morgado (4/21/2014)

    I'm sorry but I failed to get an answer from the provided link.

    I have a query that evaluates into an XML document.

    I want to read it with SqlCommand.ExecuteXmlReader.

    But the accented characters are no right. Not even when I run the query in a Visual Studio 2013 query window and open the XML result.

    Hmm, that article directly answers the first question and implicitly the latter, looks like those where not the questions you meant to ask. To clear things, please respond to LutzM's post.

    😎

  • April 21, 2014 at 8:02 am

    #1707456

    Looks like my data is in some strange collation that I can't find out what it is, and that is my problem.

    Sorry to have wasted your time.

  • April 21, 2014 at 8:47 am

    #1707469

    paulo.morgado (4/21/2014)

    Looks like my data is in some strange collation that I can't find out what it is, and that is my problem.

    Sorry to have wasted your time.

    There's no time wasted so far 😉

    All we asked you for is an example of what you're struggling with instead of verbal descriptions. Please keep in mind that we can't look over your shoulder so we don' see what you see.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply