Eric, the column type will limit the number of characters per row. A column of type TEXT will hold up to 65,535 characters but with LONGTEXT you can put up to 4,294,967,295 charcters into one row. I have an application with Texts of up to 200 pages in one column. Full-Text Search is handling this very well.
Thomas Spahni On Tue, 14 Dec 2004, EP wrote: > I've looked in the documentation but didn't see any indication of the > limits of Full-Text Search in terms of how many characters/words it can > process per row. > > For example, if I have a column with 4,000 character strings in it, can > I use it effectively in Full-Text Searching? > > What if the column holds gigabytes of text in each row? > > My mind is probably stuck in an "indexing" paradigm, but I'd like to > know where the limits (of Full Text search) are, if any. > > Can anyone advise? > Eric Pederson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
