Hi Andrea, The ' isn't NOT a stopword, it's simply not a word-boundary character, which I think is what you want. And there is no way I know of to change that in MySQL... unless you edit the source of course and compile it yourself. :-) Is that an option for you? If so, I think you just need to change 1 line in myisam/ftdefs.h:
#define misc_word_char(X) ((X)=='\'') change that to: #define misc_word_char(X) (0) I HOPE that is correct! ;-) Matt ----- Original Message ----- From: "Andrea Gangini" Sent: Thursday, June 10, 2004 9:44 AM Subject: Help with apostrophe and FTS > Is there the possibility of making the apostrophe char ( ' ) a stopword in > mysql? > Full text search queries in italian or other European language are greatly > affected by that; for example searching "amore" will not return "dell'amore" > as a match.... > Any workaround suggested? > > Andrea Gangini [EMAIL PROTECTED] Mimesi Srl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]