Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with XMLType attribibutes? please confirm

Re: Problem with XMLType attribibutes? please confirm

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 03 Aug 2005 20:07:25 +0200
Message-ID: <dcr0oe$cun$1@news2.zwoll1.ov.home.nl>


Results from a windowsed sqlplus (sqlplusw.exe):

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

DATA_CHAR



<document>

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

<document>

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

Same query, now from a command-line sqlplus.exe, active codepage: 437 or 1252 (no difference):

DATA_CHAR


<document>

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

<document>

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

So, I will keep my reservations about the tools in use.

-- 
Regards,
Frank van Bortel
Received on Wed Aug 03 2005 - 13:07:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US