Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
I've an issue with xmlserialize function - I'd like to use it to beautify xml. Unfortunately once I set indent it changes encoding in header
to : encoding="ISO-8859-1"
MY DB NLS_CHARACTERSET is WE8ISO8859P1
with src as
(
select
xmltype(
'<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Emp fullname="Den Raphaely">
<column name = "HIRE_DATE">1994-12-07</column>
<column name = "department">30</column>
</Emp>') val from dual
)
select
xmlserialize( content val) as res1,
xmlserialize( content val indent size=5) as res2
from src
in res1 there no encoding change, once I provide indent size encoding is changed - as in res2. Is there any way to avoid it?