September 7, 2009 at 4:47 am
HI,
does full text search, search number or symbols ?
if answer is no, how can i search number or symbols in a character fields(I want to use full text search for better performance) using FTS ?
September 8, 2009 at 1:18 pm
Numbers are possiblr to be saught by configuring noise.dat file on your server and re-indexing whole content.
Special chars, however, require you to write a new language analyzer... See MSDN online for samples and details
September 8, 2009 at 4:14 pm
Can you give some examples of searches you would like to perform, the data searched, and the expected matches please?
September 8, 2009 at 9:52 pm
select *
from tblDocument
where contains(docNo,'"/abc 123 \*"')
September 8, 2009 at 11:21 pm
benyos (9/8/2009)
Numbers are possiblr to be saught by configuring noise.dat file on your server and re-indexing whole content.Special chars, however, require you to write a new language analyzer... See MSDN online for samples and details
How can I edit noise words in SQL server 2008
in 2005 : C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData
but I dont know where are these in 2008 ?
September 8, 2009 at 11:23 pm
benyos (9/8/2009)
Numbers are possiblr to be saught by configuring noise.dat file on your server and re-indexing whole content.Special chars, however, require you to write a new language analyzer... See MSDN online for samples and details
How can I edit noise words in SQL server 2008
in 2005 : C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData
but I dont know where are these in 2008 ?
September 9, 2009 at 6:26 am
farax_x (9/8/2009)
select * from tblDocument where contains(docNo,'"/abc 123 \*"')
That exact example works fine for me in 2008.
September 9, 2009 at 6:40 am
farax_x (9/8/2009)
How can I edit noise words in SQL server 2008
In Management Studio, expand your database name, then Storage. There you will find full-text stop lists.
See Stop words and stop lists for an overview.
It seems you are fairly new to this. I would encourage you to read up on it (Books Online, MSDN, TechNet, Google, buy a book, whatever works) have a play around with a Trial or Developer Edition of 2005/2008, and post back if/when you hit insurmountable problems 🙂
Many people learn best by doing. YMMV of course.
Paul
September 9, 2009 at 11:25 pm
Paul White (9/9/2009)
farax_x (9/8/2009)
How can I edit noise words in SQL server 2008In Management Studio, expand your database name, then Storage. There you will find full-text stop lists.
See Stop words and stop lists for an overview.
It seems you are fairly new to this. I would encourage you to read up on it (Books Online, MSDN, TechNet, Google, buy a book, whatever works) have a play around with a Trial or Developer Edition of 2005/2008, and post back if/when you hit insurmountable problems 🙂
Many people learn best by doing. YMMV of course.
Paul
thanks for your kind response, I'll think of your advice 😛
September 9, 2009 at 11:28 pm
Paul White (9/9/2009)
farax_x (9/8/2009)
How can I edit noise words in SQL server 2008In Management Studio, expand your database name, then Storage. There you will find full-text stop lists.
See Stop words and stop lists for an overview.
It seems you are fairly new to this. I would encourage you to read up on it (Books Online, MSDN, TechNet, Google, buy a book, whatever works) have a play around with a Trial or Developer Edition of 2005/2008, and post back if/when you hit insurmountable problems 🙂
Many people learn best by doing. YMMV of course.
Paul
thanks for your kind response, I'll think of your advice 😛
September 10, 2009 at 8:54 pm
Cool. Post back if/when you get stuck.
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply