Encoding of accents in XML
cscetbonSep 28 2006 — edited Sep 29 2006Hi people,
I'm inserting XML which contains the quote character into an xmltype table. When I select the entire XML string quotes are replaced with html encoded quotes but not when I use extractvalue function to get the string which make me crazy :
create table test of xmltype;
insert into test values (xmltype('<?xml version="1.0" encoding="UTF-8"?> <FOO> c''est toi émilie ?</FOO>'));
select * from test;
SYS_NC_ROWINFO$
--------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<FOO> c'est toi émilie ?</FOO>
select extractvalue(object_value,'/FOO') object from test;
OBJECT
--------------------------------------------------------------------------------
c'est toi émilie ?
what's going on ?
My aim is to get what I inserted.