Reducing to CNF - Conjuntive Normal Form

2004-03-08 Thread Roberto Slepetys Ferreira
Hi, I am construction a Full Text Search engine replacing the internal MySQL engine in an experiment for index all the content of neswspaper's 20 years of publications , and the first layer to do a search is to convert the Boolean Phrase entered by the user to a CNF (conjuntive normal form). I su

Re: COLLATION

2004-03-06 Thread Roberto Slepetys Ferreira
It worked !!! I used the latin1_bin collation. Thanks! SLepetys - Original Message - From: "Jeremy March" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 07, 2004 12:14 AM Subject: COLLATION > > But when I do a select for specifcly word like sao, I get all the three !!

Re: NULL versus just empty

2004-03-06 Thread Roberto Slepetys Ferreira
With NULL you can check it usign the IS NULL operator. NULL could be a different use from the programer, like a row that IS NULL is a ROW that never have a data in that column, but a row with no data could be a row that was changed to that value. You could define the default value when is constru

COLLATION

2004-03-06 Thread Roberto Slepetys Ferreira
Hi, I am using MySQL for a textual database in portuguese (brasilian). When I use the FTS index, the search behavior is strange, and when I dump the index using the fts_dump, there are several words that repeat itself in the index. For my surprise, the performance of the FTS for boolean search w

ft_stopword_file

2003-06-03 Thread Roberto Slepetys Ferreira
Hi, I am creating a StopWord File in Brazilian Portuguese for MySQL based in statistical ocourrence of common words of a very large database, but it isn't working correctly: 1) I changed the ft_stopword_file in my.conf pointing to a file where I put the stopwords (each line one word). 2) Seeing