ConText and base

From: Honza Pazdziora <adelton_at_fi.muni.cz>
Date: Wed, 6 Jan 1999 10:26:20 GMT
Message-ID: <F54vnw.90o@news.muni.cz>

Hello,

I'm struggling with base_letter feature of the ConText Cartrige (Oracle 8.0.4.0.0 on Solaris, ConText 2.3.6.0.0).

I'm trying to set the index in such a way that the diacritics is stripped. Here's my SQL code:

---
create table ctx_test1 (id number, doc clob);

alter table ctx_test1 add primary key (id);
insert into ctx_test1 values (1, 'krtek leta');
insert into ctx_test1 values (2, 'krtek léta');
insert into ctx_test1 values (3, 'krtek létá');

begin ctx_ddl.set_attribute('base_letter', 1); end; /
begin ctx_ddl.create_preference('strip_dia1',

'Strip diacritical marks', 'BASIC LEXER'); end; /
begin ctx_ddl.create_policy(policy_name => 'test_policy',

colspec => 'ctx_test1.doc', lexer_pref => 'strip_dia1'); end; /
begin ctx_ddl.create_index('test_policy'); end; select * from ctx_test1 where contains(doc, 'leta', 1) > 0; ---

I expect this select to find all rows but it only finds the first one. So no conversion to base letter took place.

The database is created with

and the result is the same no matter how I have my NLS_LANG env. variable set in the client: american_america.EE8ISO8859P2, czech_czechoslovakia.EE8ISO8859P2, czech_america.EE8ISO8859P2.

My question is: did anyone have a success in getting base_letter to work? Did I miss something in the setup? When and to which value should I set the NLS_LANG variable?

Seems like a lot of questions but I'm out of ideas. The docs only mention it's possible to do this but with no real life example. When I check the setting from a GUI front end from my NT box, the settings are there (even if the menus are somehow shifted). Maybe some more detailed way of watching the ctx server might helps me see where the problem is but I'm only aware of the server log that doesn't say what parameters it's indexing with.

Any hint is greatly appreciated,

Honza Pazdziora | adelton@fi.muni.cz | http://www.fi.muni.cz/~adelton/

Boycott the Czech Telecom -- www.bojkot.cz

Received on Wed Jan 06 1999 - 04:26:20 CST

ConText and base_letter