Re: Problem with XMLType attribibutes? please confirm

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 03 Aug 2005 19:07:26 +0200
Message-ID: <dcqtke$rm9$3@news.BelWue.DE>

Ko van der Sloot wrote:
> 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

Or it's my linux...

>
>

>>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 ü.
>

Ok, so now we might be getting somewhere.

[...]

>
> SQL> select data_char from my_table where contains(data_char,'1
> inpath(//au/@id)' ) > 0;
>
> DATA_CHAR
> --------------------------------------------------------------------------------
> <document>
> <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>
Sorry, I'm out of my depths here, but what does

        select extract (data_char, '/document') from my_table

return?

Regards,
Holger Received on Wed Aug 03 2005 - 12:07:26 CDT