Re: Help with apostrophe and FTS

2004-06-11 Thread Pete Harlan
On Fri, Jun 11, 2004 at 03:34:14PM +0300, Egor Egorov wrote: > "Andrea Gangini" <[EMAIL PROTECTED]> wrote: > > > > > Well yes, it's an option. I really need this functionality. But > > on mysql site, under source downloads, there's this warning: " For > > maximum stability and performance, we re

Re: Help with apostrophe and FTS

2004-06-11 Thread Egor Egorov
"Andrea Gangini" <[EMAIL PROTECTED]> wrote: > Well yes, it's an option. I really need this functionality. > But on mysql site, under source downloads, there's this warning: " For > maximum stability and performance, we recommend that you use the binaries we > provide. " > > Is it really true? Ab

Re: Help with apostrophe and FTS

2004-06-11 Thread Andrea Gangini
> The ' isn't NOT a stopword, it's simply not a word-boundary character, > which I think is what you want. Yes, I expressed myself badly, but you have just greatly understood my problem. > change that in MySQL... unless you edit the source of course and > compile it yourself. :-) Is that an opti

Re: Help with apostrophe and FTS

2004-06-11 Thread Matt W
k 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

Help with apostrophe and FTS

2004-06-10 Thread Andrea Gangini
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 P