narayanan010
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by narayanan010
-
-
XML_Code.txtXML_Code.txtI am new to the world of XML, so need a little help on how to approach this issue. On trying to generate an XML file using an Oracle code, I obtain an incomplete XML tag at the end of the file. My guess is that the spanish content inside the XML is causing this. I have tried to change the encoding format from UTF-8 to ISO-8859-1, but the error still persisted. Here is a sample output:-
HTTP/1.1 200 OKServer: Apache-Coyote/1.1Server: DWS/4.1Cache-Control: no-cacheSet-Cookie: JSESSIONID=2551F518D867AB17F8CA73885E7F9CA2; Path=/Content-Type: text/XML;charset=UTF-8Content-Length: 729Date: Thu, 05 May 2016 12:56:37 GMT<?xml version="1.0" encoding="ISO-8859-1"?><subscriptionHistoryMA version="2.0.1"><batchAdjustmentMA><transactionId>210411850725724</transactionId><subscriberNumber>59899427796</subscriberNumber><transactionDateTime>2016-05-04T00:00:00+00:00</transactionDateTime><originNodeId>ADM_CMA</originNodeId><originNodeType>ADM</originNodeType><originTransactionId>527600</originTransactionId><transactionType>TT01</transactionType><transactionCode>ADC</transactionCode><accountStatus>10000000</accountStatus><accountGroupId>NULL</accountGroupId><externalData1>prueba á é ü N° í ñ ó ú</externalData1><externalData2>NULL</externalData2></batchAdjustmentMA></subscriptionHiThis in turn causes a parsing error while trying to read the XML file through a browser, which is expected.
The code used to generate this XML file is attached for reference.Any clues would be of great help.Thanks,Narayanan.XML_Code.txt
Oracle Code generates incomplete XML tags in case of Spanish content
in XML
Posted
Originally, I had encoding format set to UTF-8. In that case the final tag was missing, and also the Spanish characters showed up as GARBAGE VALUES. I knew the source code for the Encoding version and was able to change it to ISO-8859-1.
Any tips on how to change the CHARSET value mentioned here?
Content-Type: text/XML;charset=UTF-8
Is this the CHARSET from OS or from the Database level, or is it hard-coded in some config file?