Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 02 Feb 2006 04:59:39 -0600 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.server References: <1138876736.816301.227690@z14g2000cwz.googlegroups.com> Subject: Re: Some characters are not indexed Date: Thu, 2 Feb 2006 05:59:36 -0500 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: <1-udnXF3lq2Ge3zeRVn-rg@comcast.com> Lines: 20 NNTP-Posting-Host: 68.57.99.188 X-Trace: sv3-nEq1984IwXEgZbfKPZBDi9bR901RF836A3nCSn/tXeKuZWvDiM3EdiiKS3GwsAtHYOBHnI259VYH6sd!c+NsyIax1SgpcDsuPPVxOVrI5q0N3keTVy82RnIBRBi99IzCsjfU6/NJzrRGputNa6GrrGJE7wkE!zw== X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260551 wrote in message news: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 > how did you determine that those characters are not indexed? ++ mcs