I have a problem when using OPENXML function over data containing xml-encoding unicode character. The following example returns error: Control character in XML output! select * from openxml( '<root><element>æ</element></root>', '/root') with (element xml 'element/@mp:xmltext'); But this one without metaproperty: @mp:xmltext is correct: select * from openxml( '<root><element>æ</element></root>', '/root') with (element xml 'element'); The last character, which does not cause a problem is ¸. Used server dbsrv11.exe 11.0.1.2837 runnig on W2003 and the database was generated by command: Thank you for help asked 31 Aug '12, 10:39 Jan24 |