Hi Peter, I don't know what your multiple languages are, but remember that full-text indexing doesn't currently work with multi-byte character sets.
Anyway, the "built in" stopword list is in the myisam/ft_static.c file of the source code. This is mentioned in the manual for SHOW VARIABLES: http://www.mysql.com/doc/en/SHOW_VARIABLES.html It also says that when you specify a file, all words are used. AFAIK, the stopword file is parsed using the same word boundaries as the indexer/searcher. I just put each word on its own line. Hope that helps. Matt ----- Original Message ----- From: "Peter Björkman" Sent: Monday, October 13, 2003 8:49 AM Subject: Fulltext index, stopword list changes Hi! I'm going to use the fulltext index in an multilingual product and need to modify/translate the stopword list. According to the documentation: "The stopword list can be loaded from the file specified by the ft_stopword_file variable. See section 4.5.7.4 SHOW VARIABLES. Rebuild your FULLTEXT indexes after modifying the stopword list. (This variable is only available from MySQL version 4.0.10 and onwards)" The variable contains "built in". I can't find any information on where to find the built in list and no information on which format the stopword list should have if you create one yourself. Does anybody know more? Regards Peter Björkman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]