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.
Quote Reply
Re: [Anton_P] Search bugs in Oracle8i In reply to
See:

http://gossamer-threads.com/...orum.cgi?post=160297

Cheers,

Alex
--
Gossamer Threads Inc.