Hello,
mystore has some screws and customers like to search a given size like "6,0".
I activated fulltext serach with "AND".
Searching without "6,0" gives too many results:
https://www.skrujernet.no/no/search?q=treskrue&adv=true&adv=false&cid=0&isc=true&isc=false&mid=0&pf=&pt=&sid=true&sid=false
so customers search i.e. with "6,0" behind a type name. Both type name and "6,0" is part of productname as well as product description.
But any serchterm containing a comma either does not work at all or gives wrong results.
Why ? Is that some setting in SqlServer/storedprocedure ? It is all string so I cant see why this shouldnt work. Running SP on my SSMS gives same unwished result (nothing found).
I hope you have some ideas how to solve that.
Thanks in advance.