SQL Server Performance

XML feed UTF-8 / YUKON UTF 16

Discussion in 'SQL Server 2005 General Developer Questions' started by ramasubbup, Dec 9, 2005.

  1. ramasubbup New Member

    We are facing problem in loading xml data feed with utf-8 encoding.
    YUKON supports utf-16.

    If we comment utf-8 encoding in the data feed, then we are able to load it.

    Is there any other way to do it?

  2. Luis Martin Moderator

    I've moved to relevant forum.

    Check:

    http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=192



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. mulhall New Member

  4. ramasubbup New Member

    I have XML Data passed to a procedure as a parameter.
    This XML data comes from external system.
    Inside the procedure, I use OPEN XML to parse the input xml and dump into a table.

    The xml data has an entry 'encoding=UTF8'.

    If I remove this entry, then everything works fine.

    Since, it will be an automated system, it will be difficult to do it manually everytime.

    So, I want to know is there any other way to handle this one.




Share This Page