 |
 | 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 / December 2004Full-text search trouble
Hello , all I try to run SELECT with contains function select * from a where (a.t , '"only*"') but my query doesn't find any rows, it 's happened with the word - ONLY. What's happening? Thank you. BTW, I didn't find any articles say that ONLY is key and reserved word...... > Hello , all > I try to run SELECT with contains function [quoted text clipped - 6 lines] > > Thank you. Denis, Could you post the full output of -- SELECT @@version -- as this is most helpful information in troubleshooting SQL FTS issues. There can be several factors that can account for this behavior, one is the OS Platform that you have SQL Server installed on and if you have any punctuation characters (for example, <,>,-_,) in contact with your search word "only". Another factor is that the US English word "only" is by default in the US_English noise word file (noise.enu). Have you removed this word from your language-specific noise word file? Additionally, the English word "only" does not stem to any other form of this word. Finally, do either of the following SQL queries return the expected results? -- valid FTS contains query select * from a where contains(t, '"only"') -- valid T-SQL LIKE query select * from a where t like '%only%' Thanks, John  SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > BTW, I didn't find any articles say that ONLY is key and reserved word...... > > Hello , all [quoted text clipped - 7 lines] > > > > Thank you. Hello, John, and thank you for your answer. I use Microsoft SQL Server Yukon - 9.00.852 (Intel X86) Jul 19 2004 22:09:12 Copyright (c) 1988-2003 Microsoft Corporation Beta Edition on Windows NT 5.2 (Build 3790: ). 'Like' construction is working ok of course. Thank you it's noise word. Denis. > Denis, > Could you post the full output of -- SELECT @@version -- as this is most [quoted text clipped - 34 lines] >> > >> > Thank you. You're welcome, Denis! Ahh, I thought so, and the first noise word question/issue with Yukon (SQL Server 2005) FTS on Win2003 - and THAT is why I ask for the @@version info on nearly all of my 1st replies! Have a safe & happy Christmas! John SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > Hello, John, and thank you for your answer. > I use [quoted text clipped - 48 lines] > >> > > >> > Thank you. Thank you again... But I've a new trouble, maybe I don't understand but I have row with phrase TEST FOR SIZE if I search select * from r_message where contains (subject,'"test for size"') I find the row but if select * from r_message where contains (subject,'"test for size*"') I can't find the row. I don't understan why.....I've read BOL and didn't see anything tell me that I'm wrong..... > You're welcome, Denis! > Ahh, I thought so, and the first noise word question/issue with Yukon [quoted text clipped - 59 lines] >> >> > >> >> > Thank you. I've found solution - FOR - is also noise word...... > Thank you again... > But I've a new trouble, maybe I don't understand but [quoted text clipped - 78 lines] >>> >> > >>> >> > Thank you. |
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.