SQL Server Performance Forum – Threads Archive
XML feed UTF-8 / YUKON UTF 16We 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
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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.