 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / July 2005SQL 2005 CTP - English dictionary issues
SQL 2005 Full text indexing seems to stem "best" to "good" when using CONTAINSTABLE(FORMSOF(INFLECTIONAL. Is there anyway that I can confirm whether this mapping is due to the SQL 2005 English dictonary, and whether this entry is going to be removed, or if there is a work around. Mapping "best" to "good" is a big issue that will prevent our migration to SQL 2005 Full Text Indexing. Thanks for any help that anyone can provide. unfortunately this behavior is set in both the UK and English versions of the stemmer. UK lrtest /d /s /c:{d99f7670-7f1a-11ce-be57-00aa0051fe20} best dll loaded: C:\WINNT\system32\infosoft.dll dll version 5.0.2195.6601 file create time: 12-20-2004 1:08p file last write time: 6-19-2003 3:05p FileVersion: '5.00.2195.6601' FileDescription: 'Wordbreaker and stemmer dll' CompanyName: 'Microsoft Corporation' ProductName: 'Microsoft(R) Windows (R) 2000 Operating System' Stemmer requires license: Yes Stemmer license: 'Copyright Infosoft International Inc.' Original text: 'best' IWordFormSink::PutAltWord: cwc 4, 'best' 0x62 0x65 0x73 0x74 IWordFormSink::PutAltWord: cwc 6, 'best's' 0x62 0x65 0x73 0x74 0x27 0x73 IWordFormSink::PutAltWord: cwc 5, 'bests' 0x62 0x65 0x73 0x74 0x73 IWordFormSink::PutAltWord: cwc 6, 'bests'' 0x62 0x65 0x73 0x74 0x73 0x27 IWordFormSink::PutAltWord: cwc 6, 'bested' 0x62 0x65 0x73 0x74 0x65 0x64 IWordFormSink::PutAltWord: cwc 7, 'besting' 0x62 0x65 0x73 0x74 0x69 0x6e 0x67 IWordFormSink::PutAltWord: cwc 4, 'good' 0x67 0x6f 0x6f 0x64 IWordFormSink::PutAltWord: cwc 4, 'best' 0x62 0x65 0x73 0x74 IWordFormSink::PutAltWord: cwc 6, 'better' 0x62 0x65 0x74 0x74 0x65 0x72 IWordFormSink::PutWord: cwc 4, 'well' 0x77 0x65 0x6c 0x6c and US C:\> lrtest /d /s /c:{eeed4c20-7f1b-11ce-be57-00aa0051fe20} best dll loaded: C:\WINNT\system32\infosoft.dll dll version 5.0.2195.6601 file create time: 12-20-2004 1:08p file last write time: 6-19-2003 3:05p FileVersion: '5.00.2195.6601' FileDescription: 'Wordbreaker and stemmer dll' CompanyName: 'Microsoft Corporation' ProductName: 'Microsoft(R) Windows (R) 2000 Operating System' Stemmer requires license: Yes Stemmer license: 'Copyright Infosoft International Inc.' Original text: 'best' IWordFormSink::PutAltWord: cwc 4, 'best' 0x62 0x65 0x73 0x74 IWordFormSink::PutAltWord: cwc 6, 'best's' 0x62 0x65 0x73 0x74 0x27 0x73 IWordFormSink::PutAltWord: cwc 5, 'bests' 0x62 0x65 0x73 0x74 0x73 IWordFormSink::PutAltWord: cwc 6, 'bests'' 0x62 0x65 0x73 0x74 0x73 0x27 IWordFormSink::PutAltWord: cwc 6, 'bested' 0x62 0x65 0x73 0x74 0x65 0x64 IWordFormSink::PutAltWord: cwc 7, 'besting' 0x62 0x65 0x73 0x74 0x69 0x6e 0x67 IWordFormSink::PutAltWord: cwc 4, 'good' 0x67 0x6f 0x6f 0x64 IWordFormSink::PutAltWord: cwc 4, 'best' 0x62 0x65 0x73 0x74 IWordFormSink::PutAltWord: cwc 6, 'better' 0x62 0x65 0x74 0x74 0x65 0x72 IWordFormSink::PutWord: cwc 4, 'well' 0x77 0x65 0x6c 0x6c C:\>  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > SQL 2005 Full text indexing seems to stem "best" to "good" when using > CONTAINSTABLE(FORMSOF(INFLECTIONAL. Is there anyway that I can confirm [quoted text clipped - 5 lines] > > Thanks for any help that anyone can provide. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.