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

Some characters are not indexed

From: <boguslaw.pazur_at_marcos-bis.com.pl>
Date: 2 Feb 2006 02:38:56 -0800
Message-ID: <1138876736.816301.227690@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 Received on Thu Feb 02 2006 - 04:38:56 CST

Original text of this message

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