MySQL Forums
Forum List  »  Full-Text Search

expand full-text to allow beyond varchar(1000)?
Posted by: Bill Angus
Date: May 25, 2006 01:37PM

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.


Options: ReplyQuote

Written By
expand full-text to allow beyond varchar(1000)?
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.