XMLUpdate changes prolog!
435575Oct 2 2011 — edited Oct 3 2011I have a database with an XMLType column that has the value:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:p2="urn:gfebs.army.mil:Common_Utils" xmlns:p1="urn:gfebs.army.mil:SC-INT-4504_ObligationsCommitments" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Body>
<mns1:ObligationsCommitments xmlns:mns1="urn:gfebs.army.mil:SC-INT-4504_ObligationsCommitments">
<Item/>
</mns1:ObligationsCommitments>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
when I perform an XMLUpdate statement to actually add the meat to the SOAP package by replacing the Item Tag, the resulting XML
looks like this-
<?xml version="1.0" encoding="WINDOWS-1252" standalone="no"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:p2="urn:gfebs.army.mil:Common_Utils" xmlns:p1="urn:gfebs.army.mil:SC-INT-2029_ObligationsCommitments" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Body>
<mns1:ObligationsCommitments xmlns:mns1="urn:gfebs.army.mil:SC-INT-2029_ObligationsCommitments">
<Item>
<CyCseLn>EGOAA001</CyCseLn>
<Req>BG53751173D035</Req>
<Item/>
</mns1:ObligationsCommitments>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
How can I stop the encoding in the prolog from being changed to encoding="WINDOWS-1252"? I want to stay with UTF-8.
Edited by: ga**** on Oct 2, 2011 2:30 PM