Tag Info

New answers tagged

0

Because Compact Edition is deprecated and doesn't support full-text search (or anything like it), I think the best solution here is to stop using Compact Edition and instead use SQL Server Express with Advanced Services, which includes full-text search capabilities. Stop moving database files around between developers. This is just dangerous, regardless of ...


1

When every document is about shoes, then the term "shoe" will likely do little for the relevancy score, which may be enough of a filter in many cases. Still, as you point out, if there are no sport shoes and a document contains multiple occurrences of "shoes", that document may be considered relevant enough to be included in the result and without ...


1

According to the MySQL Documentation on FULLTEXT Boolean Searching " A phrase that is enclosed within double quote (“"”) characters matches only rows that contain the phrase literally, as it was typed. The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. Nonword characters need not be ...


0

Plus sing means AND operator, - means NOT and space means OR operator. You are probably looking for MySQL to use "Mint Leaves" as a phrase while it takes you search request as "Mint OR Leaves" which leads to unexpected results. http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html You are probably need to reconstruct your query to be something like ...


1

By default MySQL uses ft_min_word_len=3 setting which tell MySQL full-text engine to ignore all the words LESS than 3 letters. You need to decrease this variable. It's not dynamic so you may need to restart MySQL. However setting it to less than 3 may affect performance.


0

The solution was to set the DacDeployOptions.ScriptDatabaseOptions property to false. This removed the full-text search logic from the deployment execution (both the SQLCMD script and the DacServices.Deploy(...) method).


1

Edited: It looks like the answer is: No, you cannot create a full-text index in a system database. You can, of course, run a script to turn on a full-text indexing after the new database is created from model, if that is necessary. But by default all user databases in the more recent versions of SQL Server have full-text indexing turned on automatically. ...



Top 50 recent answers are included