MySQL Forums
Forum List  »  Full-Text Search

. and / are stopwords?
Posted by: Pekka Saarinen
Date: August 23, 2005 04:05PM

Problem: I need to search camera apertures and shutter speeds, e.g.

1.8

1/100

I have set the default minimum word length to 2, but fulltext handles above keywords with loosing the . or / and treating 1 and 8 and 1 and 100 as separate keywords. This of course does not produce desired search result.

How can I make fulltext accept these special characters?

I have RHEL4, MySQL 4.0.25 compiled from source using

./configure \
--prefix=/somepath/mysql \
--enable-assembler \
--with-mysqld-ldflags=-all-static \
--without-innodb \
--with-server-suffix=-something \
--enable-thread-safe-client \
--enable-local-infile \
--with-client-ldflags=-all-static \
--disable-maintainer-mode \
--with-mysqld-user=someuser \
--with-unix-socket-path=/somepath/mysql.sock \
--without-comment \
--without-debug \
--without-bench
--disable-shared

Options: ReplyQuote


Subject
Views
Written By
Posted
. and / are stopwords?
3515
August 23, 2005 04:05PM
2702
March 30, 2007 09:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.