I use FTS and it returns for query "Møreforsking" results contains "Møre" as a separate word. I understand that "Møre" and "forsking" are different words and can be use separatly. How can I avoid the problem? I want to search only for whole word in described case.
MS SQL SERVER FTS FREETEXTTABLE search by part of word
396 views Asked by BotanMan At
1
There are 1 answers
Related Questions in SQL-SERVER-2008
- Twitter Bootstrap horizontal form elements on a line
- posting javascript populated form to another php page
- Call a method in a .cs from javascript
- HTML5 form input reacting to enter key
- Why HTML5 required field is not mandatory, if form posted to two different pages using JavaScript?
- django form errors before submit
- PHP Contact Form returning error upon submission
- PHP form validation: Where to plop the code
- javascript check input fields are not blank and check input field length?
- Show success or error messages in Ajax response to Wordpress custom registration form
Related Questions in FULL-TEXT-SEARCH
- Twitter Bootstrap horizontal form elements on a line
- posting javascript populated form to another php page
- Call a method in a .cs from javascript
- HTML5 form input reacting to enter key
- Why HTML5 required field is not mandatory, if form posted to two different pages using JavaScript?
- django form errors before submit
- PHP Contact Form returning error upon submission
- PHP form validation: Where to plop the code
- javascript check input fields are not blank and check input field length?
- Show success or error messages in Ajax response to Wordpress custom registration form
Related Questions in FREETEXTTABLE
- Twitter Bootstrap horizontal form elements on a line
- posting javascript populated form to another php page
- Call a method in a .cs from javascript
- HTML5 form input reacting to enter key
- Why HTML5 required field is not mandatory, if form posted to two different pages using JavaScript?
- django form errors before submit
- PHP Contact Form returning error upon submission
- PHP form validation: Where to plop the code
- javascript check input fields are not blank and check input field length?
- Show success or error messages in Ajax response to Wordpress custom registration form
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Im not sure what codepage you are working in so I can't easily test it (
SELECT 'language_id' AS "LCID" FROM sys.fulltext_index_columns;); if the word breaker is splitting the words up and considering moreforsking as two words for matching. You can test word breakers usingif that is returning two words More and forsking then you need to tell FTS about your word Moreforking. You can create your own custom dictionary and add the word in if it is missing. The linked microsoft technet is a little confusing on this as it says follow the Sharepoint instructions but save in a sql folder.
The basics are
Save the file into your SQL Instance (sometimes its like this)
C:\Program Files\Microsoft SQL Server\\MSSQL\Binn
get FTS to load the dictionaries by restarting the FTS daemon.
exec sp_fulltext_service 'restart_all_fdhosts'
The bad news is you will need to reindex for it to take effect; so I would try it in test and read the share point article if you have a LOT of data that is indexed.