this is the first time i m using full text search. I am trying to search for the text entered by user and i search for that text in three columns.
if it is a normal search i can avoid invalid characters but which character do i need to make sure are not there in the search string for full text...
if i enter "test" in the search box with double quotes returns an error if i enter a search called (test without the closing braces it returns an error.
so my question is what are the characters to be avoid or be replace by in the a full text search string
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert