Post by mostek » Wed Feb 16, 2011 7:30 pm

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

Newbie

Posts

Joined
Wed Feb 16, 2011 7:20 pm

Post by mostek » Thu Feb 17, 2011 4:47 pm

I have got the same problem on newest Version 1.4.9.3!

Please - help me with this issue.

Newbie

Posts

Joined
Wed Feb 16, 2011 7:20 pm

Post by Hildebrando » Thu Feb 17, 2011 7:36 pm

Hi:

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


User avatar
Active Member

Posts

Joined
Fri Mar 06, 2009 8:22 pm
Location - Spain
Who is online

Users browsing this forum: No registered users and 63 guests