Hi
Can you help on the following please.
1) Search how can this be activated to search for example for a 17" Lcd Screen
Thanks
Roy
Hi David
Thanks for your comments re the search.
What about the ability to allow " as a parameter in the search is this possible.
Regards
Roy
Hi Roy,
The " symbol is one of the characters that is stripped during the quite aggressive normalisation that takes place during the import process. By allowing that character it would be quite possible to break the search function and create invalid URLs.
However, because it is stripped from the import, it is also stripped from the query before the search is performed (the normalisation function is used in both cases), so the effect should cancel out.
I can appreciate from this, and your previous thread, what it is that you are trying to achive so I will have a think about how best to handle this situation. It would help if you are able to post (or email to me) example products on your site and what queries you would like to find those products, then I can look at the SQL that is used and see what could be done.
Cheers,
David.
Hello Roy,
This is one of the limitation of using full text indexing. Whilst it is great for most situations, where a query of at least 4 characters contains words of 3 or less, those words are ignored.
This is done for performance reasons, and is the default setting in MySQL for the Full Text index. If the query is less than 4 characters in total, the normal index is used.
Now, it would be possible to write code to split the query up into words and use the full text only if all words are at least 4 characters; however this does mean that an exact match would be required - and this might mean that less people would actually find the product they were looking for as a result...