Andrew Hardy wrote:
> Ko van der Sloot wrote:
>
>> Hello,
>> we encountered a very strange problem with searching in our XMLType
>> database.
.....
insert into my_table values( 1, XMLType(
'<document>
<au first="Rüdiger" id="1">Rüdiger</au>
</document>' ) );

insert into my_table values( 2, XMLType(
'<document>
<au first="Ruediger" id="1">Rüdiger</au>
</document>' ) );
....
> On my box:
....
> <document>
> <au first="R?diger" id="1">R?diger</au>
> </document>
>
> <document>
> <au first="Ruediger" id="1">R?diger</au>
> </document>

In your reply, ü (small caps u with diaeresis) was replaced by ?
If this already happened at the moment the records were created,
nothing is proved yet.
So now I'm still not sure if it realy worked well in Oracle 10
can you please confirm that the output contains real UTF8

sorry for the inconvenience

Ko vd Sloot