on 2012 Aug 31 11:39 AM
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:
dbinit.exe -a -p 4096 -ze cp1250 -z uca(locale=sk)
Thank you for help
Request clarification before answering.
User | Count |
---|---|
60 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.