Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Search bugs in Oracle8i

Quote Reply
Search bugs in Oracle8i
Hello,

I address to Alex first of all.
When i change Search type from Indexed to Regular, it can not do search.
The reason is that Oracle cannot do selects like this:

SELECT * FROM Category WHERE Description LIKE '%query%';

and there is such SQL-Operator in Links/User/Search.pm file.

The field Description (TEXT type in MySQL) in Oracle8i is CBLOB type, and this type can not be checked by word LIKE in Oracle.

Also there are many bugs in Indexed search.
What should i do?
Anton Permyakov.
Subject Author Views Date
Thread Search bugs in Oracle8i Anton_P 813 Sep 24, 2001, 9:28 PM
Post Re: [Anton_P] Search bugs in Oracle8i
Alex 727 Sep 25, 2001, 1:21 PM