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!

printjoins/skipjoin : middle dot

FabriceCNov 21 2017 — edited Nov 21 2017

Hi,

I'im using Oracle Text (11.0.2.4.)

A context index is created on a clob column, which contain french text. In these text, there are middle dot (U+00B7)

I want to add middle dot in skipjoin characters :

BEGIN

CTX_DDL.CREATE_PREFERENCE('LEXER_GPSR_ACI', 'BASIC_LEXER');

CTX_DDL.SET_ATTRIBUTE('LEXER_GPSR_ACI', 'BASE_LETTER', 'YES');

CTX_DDL.SET_ATTRIBUTE('LEXER_GPSR_ACI', 'MIXED_CASE', 'NO');

CTX_DDL.SET_ATTRIBUTE('LEXER_GPSR_ACI', 'BASE_LETTER_TYPE','SPECIFIC');

CTX_DDL.SET_ATTRIBUTE('LEXER_GPSR_ACI', 'skipjoins','·'); -- middle dot U+00B7

END;

Oracle Text doesn't index correctly, skipjoins is not taken into account: With or without adding skipjoins character, words with middle dot are separated in two word --> abc·def is indexed in abc and def and i want to have abcdef .

Not all characters can be added in skipjoins ??

How can I change this ?

Thanks

Regards

Fabrice

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2017

Added on Nov 21 2017

#database-key-features, #text

3 comments

1,059 views