Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2011-12-04 : 18:41:46
|
| Hi.I have some questions i want to ask.After creating the Full-text catalog there are various thoughts i have.Firstly using Contains or Freetext.What i read is that freetext will match the meaning and since the search catalog will be for a Greek site i don't know how freetext will behave.Anyhow i can live with search for the exact word with contains so i'll go the the immediate problems.1)I want the search to be multinational.I want both English and Greek.Do i need to use lcid or it is automated?If i need lcid i can't find the Greek language id on msdn (http://msdn.microsoft.com/en-us/library/ms176076.aspx) and if supposedly i turn it to Greek will this prevent English searching?2)I want a multiple word search so since this will be an asp.net site with sql am i to assume that taking the search words from the site putting them in " " and passing everything on a wordsearch @variable of a stored procedure will work and prevent sql injection?3)One final thing.I can't recall right now because my mind is steaming from the reading i am doing for this but there is a property that eliminate the,i can't recall the English name, words that they are command words,like: or,and,the ...etc.This is fine if you are using English but how can this be done on Greek words?Have Microsoft done something similar or i need to cut them manually?Thanks. |
|
|
|
|
|
Help on full text search