expand full-text to allow beyond varchar(1000)?
Is there a way to upgrade the MySQL full-text index to allow more than 1000 char/record indexing?
I have a catalog of materials stored in MySQL. I'm trying to incorporate a google-type search where users can search by Title, Author or Description words. The last one is giving me a problem.
In my case, the database has about 1500 items in it. Each item has a description (mediumtext -- in practice up to 2000 characters long though but most are ~ 500 characters). Titles are varchar(100), Authors are varchar(100).
Any info greatly appreciated.
Bill.
Subject
Views
Written By
Posted
expand full-text to allow beyond varchar(1000)?
4342
May 25, 2006 01:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.