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 05:59:36 -0500
Message-ID: <1-udnXF3lq2Ge3zeRVn-rg@comcast.com>

<boguslaw.pazur_at_marcos-bis.com.pl> wrote in message news:1138876736.816301.227690_at_z14g2000cwz.googlegroups.com...
> Hello,
>
> I have index on varchar2 column. NLS_SORT is set as Polish and NLS_COMP
> is ANSI. But characters like '.', '?', '-' are not indexed (it seems
> that only digits, letters and space are indexed). How can I make server
> to index those characters? Server is 0racle 10.2.0.
>
> TIA
>
> Boguslaw Pazur
>

how did you determine that those characters are not indexed?

++ mcs Received on Thu Feb 02 2006 - 04:59:36 CST

Original text of this message

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