Re: Problem with XMLType attribibutes? please confirm

From: Ko van der Sloot <Ko.vanderSloot_at_uvt.nl>
Date: Wed, 03 Aug 2005 16:08:03 +0200
Message-ID: <dcqj43$cs0$1@troll.uvt.nl>

Holger Baer wrote:
> Ko van der Sloot wrote:
>

>> Frank van Bortel wrote:
>>
>>> Ko van der Sloot wrote:
>>> This has little or nothing to do with Oracle, and everything with:
>>> a) the tool you use to display the results
>>> b) the platform you use
>>
>>
>>
>> please reread the discussion:
>>
>> First: I posted an example containing ü characters.
>> Some of them were correctly retrieved. Others not.
>> So our Oracle DB is capable of storing and retrieving ü, yes?

>
>
> I must have missed something, because your original post as I received
> it, didn't contain data retrieving.

oeps: I didn't include it, because it was so obvious (to me, that is) sorry. I said I expected te retrieve both record. implying that only one was retrieved.
At the end I will include the whole session.

>> BUT: In his mail all ü characters were mangled. so it was unclear to me
>> if he realy entered ü characters in hit DB or that they were already
>> mangled beforehand.

>
>
> Tested on SLES8/10gR1: Same result as Andrew. You put in 'ü' but (possibly
> in the xmltype constructor) they got mangled.
>

>>
>> Then: I asked to clearify this. But he didn't upto now.

>
> I'll do on his behalf: They seem to get mangled. But then tested in a
> plain varchar2 field the 'ü' gets mangled too.

Then your Oracle isn't UTF8 aware I guess. It isn't mangled here. But Oracle just can't find one of the records

> Important information that, if supplied in the first place wouldn't have
> led Frank (and indeed me, too) on the wrong path.

Sorry about that. There are so many variables.... As said: it was clear to me that this isn't a simple 'codepage' problem, because we are able to retreive numerous UTF8 character strings. Only not if there are UTF characters in an XML attribute (which is NOT used at all, in the example)

> Now that all the confusion is hopefully resolved, could you please post
> *your*
> results when you execute the query.

Commin up....

> Sofar I for one don't even know what this thread is *really* about.

About Oracle XML text search failing when some attribute contains ü.

> Regards,
> Holger

Thanks for your patience...

Ko vd Sloot
The whole session:

SQL> drop table my_table;

Table dropped.

SQL> create table my_table ( doc_id NUMBER, data_char xmltype );

Table created.

SQL> insert into my_table values( 1, XMLType( 2 '<document>
3 <au first="Rüdiger" id="1">Rüdiger</au> 4 </document>' ) );

1 row created.

SQL> insert into my_table values( 2, XMLType( 2 '<document>
3 <au first="Ruediger" id="1">Rüdiger</au> 4 </document>' ) );

1 row created.

SQL> create index my_table_idx on my_table(data_char) indextype is ctxsys.context;

Index created.

SQL> select data_char from my_table where contains(data_char,'1 inpath(//au/@id)' ) > 0;

DATA_CHAR

<au first="Ruediger" id="1">Rüdiger</au> </document>

SQL> select * from my_table;

DOC_ID

DATA_CHAR

1
<document>

<au first="Rüdiger" id="1">Rüdiger</au> </document>

2
<document>

<au first="Ruediger" id="1">Rüdiger</au> </document>

DOC_ID

DATA_CHAR

SQL> Received on Wed Aug 03 2005 - 09:08:03 CDT