Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    48

    Question Unanswered: Oracle Text and languages

    Hi,

    we have an application that uses context indexes. Normally we only had it in one language. Now there is a customer that uses 2 languages. So the application is now in both languages, also the documents inserted in the database could be both languages.

    At installation time of the Oracle Text part, you also have to create the lexer preference, wordlists, stoplists ...

    Can I, or should I load that in database for both languages? Is this possible and necessary?

    thanks
    greets
    K.

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    It depends on the type of operators you are using or planning to use in your queries. For example, you can use STEM ($) for some languages included in the BASIC_LEXER, for other languages, you will need another LEXER...

    We are currently working in both French and English indexed texts and only interested in NOT (~), AND (&) and OR (|) searches. As far as making both languages work well together is concerned, we just created a custom list of stopwords that include english and french stopwords. I would say that it is the minimum needed, since otherwise you would index lots of useless words, polluting searches as well as increasing index sizes. For now we haven't seen the need to change another parameter.

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •