Re: Help with apostrophe and FTS
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]
Re: Help with apostrophe and FTS
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 option for you? 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? 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]
Re: Help with apostrophe and FTS
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? Absolutely. There are too many ways to build MySQL so that it will not work well... buggy compilers, thread stack size, etc. Especially this applies to Linux, because MySQL build is statically linked with a bit patched glibc version. And glibc compilation by itself is tricky. So if you need rock stability on Linux and still need to have a custom built binary you can subscribe to Primary support or Login installation packages. Both include custom binaries build. Click on the link below to learn more. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with apostrophe and FTS
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 recommend that you use the binaries we provide. Is it really true? Absolutely. There are too many ways to build MySQL so that it will not work well... buggy compilers, thread stack size, etc. Especially this applies to Linux, because MySQL build is statically linked with a bit patched glibc version. And glibc compilation by itself is tricky. While I'm sure this is true, for the last 6+ years we've essentially always compiled our own MySQLs under Debian and never had a problem that I wasn't able to reproduce with the precompiled version. [I say essentially always because we did use a precompiled version for a while once, but it had a bug that went away when we compiled it ourselves. That was years ago and was a rare case where the precompiled version did have a problem with its static libs that was disovered by MySQL and fixed shortly thereafter.] I'm not saying this to contradict the good folks at MySQL or to disparage their fine binary builds, only to say that their (and Debian's) software is so good that in my experience you shouldn't be *that* worried about compiling it yourself. (Of course, if you have problems and expect any help with it, paying for support sounds like a good idea.) --Pete So if you need rock stability on Linux and still need to have a custom built binary you can subscribe to Primary support or Login installation packages. Both include custom binaries build. Click on the link below to learn more. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]