MySQL Forums
Forum List  »  Full-Text Search

non english stopwords are not working
Posted by: Mohammad Ghayoumi
Date: December 31, 2007 03:43AM

db ver:5.0.41-community-nt
MySQL charset: UTF-8 Unicode (utf8)

I have a table with 2 columns with fulltext index.
Table Collation: utf8_general_ci
column1 and column2 Collations : utf8_unicode_ci;
the data is in english and persian.

I changed this 2 parameters in my.ini
ft_stopword_file = c:\\www\\stopwords.txt

this the show variables query :
ft_max_word_len 84
ft_min_word_len 2
ft_stopword_file c:\www\stopwords.txt

the Fulltext works OK, No problem.
but the Persian words in the stopword is not affecting the fulltext index!
I tested and saved the stopword.txt with ASCII,UTF8 without byte order marking, UTF8 with byte marking.
No difference, Only English words takes effect in stop words.
maybe it is very simple but I don't understand.
Please Help .

Thank you in advance.

Options: ReplyQuote

Written By
non english stopwords are not working
December 31, 2007 03:43AM

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.