Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

nls_language to be set for english stop words to work,10gR2 on Linux

670231Jul 28 2009 — edited Jul 28 2009

Hi,

When we search a phrase using contains and if the phrase has a stop word in it then the stop word is identified by Oracle depending upon the session language.

When I set the nls_language for the session to AMERICAN, stop word is not being detected and when I set the language to 'ENGLISH', it is being detected.

Is this because the english being refered in the Full Text corresponds to 'ENGLISH' and not 'AMERICAN'.

I guess it should refer to both american and english also.

It would be nice if anyone can clarify this ASAP.

Thanks a lot in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2009

Added on Jul 28 2009

#database-key-features, #text

11 comments

3,503 views