I was wondering if anyone can help. I have realised that the search function only works with an exact match. Is there a way for the search to work irrespective of the word has a capital letter or not?
Thank you in advance.
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Regards,
Straightlight
Programmer / Opencart Tester
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
http://demo.getclearthinking.com/index. ... search=mac
http://demo.getclearthinking.com/index. ... search=Mac
I'd suggest you start looking through mods you've installed, and disable any that you think might be affecting this. If you really can't figure it out, you could get Smart Search, which I can guarantee uses case-insensitive searching, or you could hire someone to take a look at the issue for you.
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Regards,
Straightlight
Programmer / Opencart Tester
straightlight wrote: ↑Tue Apr 03, 2018 10:04 pmThe only location for product search that would be case-sensitive would be the product description field compared to other fields that may be lookup in the database since the LCASE function (lower case) is not being used with the default installation of OC. All other fields, so far, seem to use this function which would, then, be correct stating that the case-sensitive search does not matter at this point.
The searches still work because of the database collation (utf8_general_ci, where ci = case-insensitive). For example, see this search for a word in the product description, which is only capitalized, but still shows the right products:
http://demo.getclearthinking.com/index. ... ption=true
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Regards,
Straightlight
Programmer / Opencart Tester
Users browsing this forum: No registered users and 25 guests