| Groups | Blog | Home |
sql server full text search : Full-text search trouble
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 -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] <denis_rusakov@epam.com> wrote in message news:uh$lMHQ6EHA.2584@TK2MSFTNGP10.phx.gbl... > BTW, I didn't find any articles say that ONLY is key and reserved word...... > > <denis_rusakov@epam.com> wrote in message > news:OmK8IFQ6EHA.3856@tk2msftngp13.phx.gbl... > > 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. > > > >
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......
[quoted text, click to view] <denis_rusakov@epam.com> wrote in message news:OmK8IFQ6EHA.3856@tk2msftngp13.phx.gbl... > 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. >
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 -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] <denis_rusakov@epam.com> wrote in message news:#eW7XNZ6EHA.3828@TK2MSFTNGP09.phx.gbl... > 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. > > "John Kane" <jt-kane@comcast.net> wrote in message > news:uMj7c8R6EHA.2032@tk2msftngp13.phx.gbl... > > 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 > > -- > > SQL Full Text Search Blog > > http://spaces.msn.com/members/jtkane/ > > > > > > <denis_rusakov@epam.com> wrote in message > > news:uh$lMHQ6EHA.2584@TK2MSFTNGP10.phx.gbl... > >> BTW, I didn't find any articles say that ONLY is key and reserved > > word...... > >> > >> <denis_rusakov@epam.com> wrote in message > >> news:OmK8IFQ6EHA.3856@tk2msftngp13.phx.gbl... > >> > 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. > >> > > >> > >> > > > > > >
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. [quoted text, click to view] "John Kane" <jt-kane@comcast.net> wrote in message news:uMj7c8R6EHA.2032@tk2msftngp13.phx.gbl... > 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 > -- > SQL Full Text Search Blog > http://spaces.msn.com/members/jtkane/ > > > <denis_rusakov@epam.com> wrote in message > news:uh$lMHQ6EHA.2584@TK2MSFTNGP10.phx.gbl... >> BTW, I didn't find any articles say that ONLY is key and reserved > word...... >> >> <denis_rusakov@epam.com> wrote in message >> news:OmK8IFQ6EHA.3856@tk2msftngp13.phx.gbl... >> > 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. >> > >> >> > >
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..... [quoted text, click to view] "John Kane" <jt-kane@comcast.net> wrote in message news:e6TMoZa6EHA.2196@TK2MSFTNGP14.phx.gbl... > 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 > -- > SQL Full Text Search Blog > http://spaces.msn.com/members/jtkane/ > > > <denis_rusakov@epam.com> wrote in message > news:#eW7XNZ6EHA.3828@TK2MSFTNGP09.phx.gbl... >> 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. >> >> "John Kane" <jt-kane@comcast.net> wrote in message >> news:uMj7c8R6EHA.2032@tk2msftngp13.phx.gbl... >> > 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 >> > -- >> > SQL Full Text Search Blog >> > http://spaces.msn.com/members/jtkane/ >> > >> > >> > <denis_rusakov@epam.com> wrote in message >> > news:uh$lMHQ6EHA.2584@TK2MSFTNGP10.phx.gbl... >> >> BTW, I didn't find any articles say that ONLY is key and reserved >> > word...... >> >> >> >> <denis_rusakov@epam.com> wrote in message >> >> news:OmK8IFQ6EHA.3856@tk2msftngp13.phx.gbl... >> >> > 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. >> >> > >> >> >> >> >> > >> > >> >> > >
I've found solution - FOR - is also noise word......
[quoted text, click to view] <denis_rusakov@epam.com> wrote in message news:OfVOnta6EHA.1564@TK2MSFTNGP09.phx.gbl... > 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..... > > "John Kane" <jt-kane@comcast.net> wrote in message > news:e6TMoZa6EHA.2196@TK2MSFTNGP14.phx.gbl... >> 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 >> -- >> SQL Full Text Search Blog >> http://spaces.msn.com/members/jtkane/ >> >> >> <denis_rusakov@epam.com> wrote in message >> news:#eW7XNZ6EHA.3828@TK2MSFTNGP09.phx.gbl... >>> 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. >>> >>> "John Kane" <jt-kane@comcast.net> wrote in message >>> news:uMj7c8R6EHA.2032@tk2msftngp13.phx.gbl... >>> > 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 >>> > -- >>> > SQL Full Text Search Blog >>> > http://spaces.msn.com/members/jtkane/ >>> > >>> > >>> > <denis_rusakov@epam.com> wrote in message >>> > news:uh$lMHQ6EHA.2584@TK2MSFTNGP10.phx.gbl... >>> >> BTW, I didn't find any articles say that ONLY is key and reserved >>> > word...... >>> >> >>> >> <denis_rusakov@epam.com> wrote in message >>> >> news:OmK8IFQ6EHA.3856@tk2msftngp13.phx.gbl... >>> >> > 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. >>> >> > >>> >> >>> >> >>> > >>> > >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |