March 28, 2009 at 3:18 am
hi
Thesaurus file for full text search is xml based.... no predefined synonym is there ,we need to edit xml file for each word....is there any possibilty for predefined xml file ...to hav synonym for all word...:-)
March 28, 2009 at 6:05 am
I don't understand your question. Where are your synonyms from? If they are in database you can use the FOR XML to create the XML file. If they are in another XML file you should use XSLT.
Greets
Flo
March 29, 2009 at 10:09 pm
The thesaurus files are in XML format with a global file (tsGLOBAL.xml) and then 18 language specific files. By default all of the files have sample XML that is commented out. So by default no synonyms are setup when a full text search is issued. is there any default xml file to find synonym for all word when full text search is issued...
March 31, 2009 at 9:15 am
I don't think that you want every synonym for every word in every language to be added to the thesaurus file(s).
The thesaurus file is used for alternate names and/or spellings that are not in most dictionaries. For example "IE" is an acronym for "Internet Explorer", "PC" is another name for "computer", "car" is another name for "automobile".
First thing is to go to the Books Online (BOL) and understand the INFLECTION parameter of the CONTAINS clause.
How it works: http://technet.microsoft.com/en-us/library/ms142566(SQL.90).aspx
March 31, 2009 at 9:20 am
kavi (3/29/2009)
The thesaurus files are in XML format with a global file (tsGLOBAL.xml) and then 18 language specific files. By default all of the files have sample XML that is commented out. So by default no synonyms are setup when a full text search is issued. is there any default xml file to find synonym for all word when full text search is issued...
Yes, they are empty. No default is provided. As documented in the Books Online (BOL): http://technet.microsoft.com/en-us/library/ms345187(SQL.90).aspx
March 31, 2009 at 9:57 pm
Hi
if there is no pre filled thesaurus file with synonyms for all word,is there any alternate solution for my query?
For example: i need to find synonyms for any word for eg: the word "check" using sql query then the output should display all synonyms like the list below,
Try out
test
confirm
ensure
verify
prove
try
kindly help me with the query to execute this result...
April 1, 2009 at 6:48 am
Your example is exactly what the Thesaurus is for. There is no quick way to populate it. You'll have to add the terms to the Thesaurus as per the documentation.
April 1, 2009 at 10:12 pm
hello
i can't get the exact query of yours. kindly tell it briefly
April 1, 2009 at 10:32 pm
Hi Sir,
i need Pre filled thesaurus file to be included for full text search
April 1, 2009 at 11:32 pm
Hi
there is an function oPtion in sql-serve nAmed full text search.you might get a solution for your query by using this oPtion.kindly try it over And get your query solved
April 2, 2009 at 2:40 pm
Moved to main double-post at http://www.sqlservercentral.com/Forums/Topic686744-145-1.aspx
April 2, 2009 at 2:41 pm
This is a multiple post. The discussion has progressed further at http://www.sqlservercentral.com/Forums/Topic686744-145-1.aspx
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply