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: Some characters are not indexed

Re: Some characters are not indexed

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 2 Feb 2006 08:57:13 -0500
Message-ID: <keydneR1Z5Mhkn_enZ2dnUVZ_sSdnZ2d@comcast.com>

<boguslaw.pazur_at_marcos-bis.com.pl> wrote in message news:1138885125.094060.197370_at_g49g2000cwa.googlegroups.com...
> SELECT * FROM vendor ORDER BY name
>
> cause result
>
> Name
> ?AZ
> AZ
> BR
> ?MARC
> MARC
>
> It seems like '?' is omitted. Maybe I'm wrong and it's question of
> sorting not indexing?
>
> TIA
>
> Boguslaw Pazur
>

right, you're wrong ;-)

it is a question of sorting

not sure what the rules are for NLS_SORT = Polish, but that's what you need to investigate

++ mcs Received on Thu Feb 02 2006 - 07:57:13 CST

Original text of this message

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