XML feed UTF-8 / YUKON UTF 16 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

XML feed UTF-8 / YUKON UTF 16

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?
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.
What is the problem you are experiencing? You can handle UTF8 encoded data with a CLR DUT -user defined datatype: http://msdn2.microsoft.com/en-us/library/ms160893.aspx
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.

]]>