Tuesday, September 28, 2010

Special Characters in XML

Recently we are faced a issue with some spanish,french(special charecters) in the data .
we are developing the reports using xmlpublisher and the xml data is generated using plsql.
Because of the special characters the concurrent program is ending in warning state with no output generated. even the xml output is errroing out.

To overcome this scenario we need to add encoding tag to the xml
By default it will be UTF-8 which will support mostly english.for normal spanish characters and others all we need to have is different endcoding like Windows-1252, ISO-8859-1 specified.
The encoding tag should be mentioned as the first tag



once we put the encoding attribute, the xml file should open normally in explorer.

For Chinese and Arabic characters if this doesn't work try out "UTF-16"

3 comments:

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.