Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some characters are not indexed
<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