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.
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.