interMedia does not seem to work properly !!!

From: Kristian Holmstrøm Mikkelsen <memsi_at_stibo.dk>
Date: Thu, 23 Sep 1999 20:06:56 +0200
Message-ID: <7sdq35$mf5$1@news1.tele.dk>

1)
Why do I get this error using word stemming when large resultsets are returned (In this case I use german stemming):

"DRG-50921: EQUIV operand not a word or another EQUIV expression"

SELECT COUNT(*)
FROM "GERMANY"."PRODUCTDESC"
WHERE CONTAINS(description, '$kabel') > 0

For small resultsets, it seems to work !!

2)
And another thing, when I use Unicode(UTF8), it seems that if I want to perform a wildcard search, I have to use double '%', like:

SELECT COUNT(*)
FROM "GERMANY"."PRODUCTDESC"
WHERE CONTAINS(description, 'kab%%') > 0

...otherwise, I will hit nothing ??? Can that be true ??

---

Kristian Holmstrøm Mikkelsen, Software Developer The Stibo Group
Søren Nymarksvej 3
Postbox 1947
DK - 8270 Højbjerg
Aarhus, Denmark

Phone +45 89 39 11 11
Fax +45 89 39 11 12

memsi_at_stibo.dk
http://www.stibo.com Received on Thu Sep 23 1999 - 13:06:56 CDT