I have a problem with Opencart - Version 1.4.9.2
When I use polish national characters in search field - there are no results. When I search without polish national character everything is ok - search works great.
Have you got any idea how to fix it?
Which file (i need patch) generates search resaults and where is SQL query responsable for generating search resaults?
Thank you for help in advance.
Pete
Hi:
Search at catalog/model/catalog/product
functions: getTotalProductsByKeyword() and getProductsByKeyword()
perhaps: add to sql search string the: COLLATE utf8_unicode_ci
Best,
Hilde
Search at catalog/model/catalog/product
functions: getTotalProductsByKeyword() and getProductsByKeyword()
perhaps: add to sql search string the: COLLATE utf8_unicode_ci
Best,
Hilde
Commercial Contributions:Bulk Specials| Bulk Update Prices|Search Tyre Pro
Free Contributions: Youtube video (oc 1.5.x) | Search History Report (oc 1.5.x) | Product Filter by Category (oc 1.5.x)|Youtube Popup
More Free & commercial mods: www.fpress.com
Who is online
Users browsing this forum: Majestic-12 [Bot] and 62 guests