Forum Stats

  • 3,733,959 Users
  • 2,246,849 Discussions
  • 7,856,951 Comments

Discussions

German composite words with Oracle Text

658165
658165 Member Posts: 6
Hi,

I'm not sure, if this is an Oracle XE specific problem, but indexing german composite words does not seem to work with Oracle XE:

begin
ctx_ddl.create_preference('lexer1', 'BASIC_LEXER');
ctx_ddl.set_attribute('lexer1', 'mixed_case', 'NO');
ctx_ddl.set_attribute('lexer1', 'alternate_spelling', 'german');
ctx_ddl.set_attribute('lexer1', 'composite', 'german');
end;
/

create table qqq (a varchar2(100));
insert into qqq values ('Hauptbahnhof und Tischbein');
create index ix_qqq on qqq (a) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('LEXER lexer1');

select count(*) from qqq where contains (a, '$bahnhof') > 0;

The query above does return 0, but for some strange reason, the following query returns 1 (the only composite working):

select count(*) from qqq where contains (a, '$haupt') > 0;

Any ideas,

thanks,

Ulf
Tagged:

Answers

This discussion has been closed.