> -----Original Message----- > From: Bendick Mahleko [mailto:[EMAIL PROTECTED] > Sent: 12 August 2005 12:22 > To: mysql@lists.mysql.com > Subject: how to change ft_max_word_len value beyond 254 > > Hello, > I want to index a table using a TEXT value, with length > > 255. I tried changing ft_max_word_len but each time I check > the status of variables, I notice the changes are not taken. > It defaults to 254. I am able to change this value to > anything below 254. Is there any other way to enforce this > ft_max_word_len value to some arbitrary value above 254? > > > The point is, because my index length is being limited to > only 254, I am having false misses in my SELECT queries, > based on the TEXT index. > > Bendick >
Hi Bendick, Am I missing something here? The ft_max_word_len variable sets the maximum length of any word that fulltext will index, *not* the maximum length of the field that you are indexing. Now, unless you are indexing some scientific data, with for instance some strange, long virus name - I don't know of any word, in the English language at least, that is longer than 254 characters. I recently built a dictionary table for fun, with ~500,000 words from the English language in the table, so I can verify this for you if you want ;) Perhaps your false misses are due to something else, such as ft_min_word_len, or the values being in more than 50% of the rows etc. Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk http://leithal.cool-tools.co.uk -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.7/70 - Release Date: 11/08/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
