Page 1 of 1

Case sensitive search results?

Posted: Tue Oct 14, 2014 5:28 pm
by unknownmale1
I'm now using

in 1.5.2 It didn't seem to matter if the product titles or descriptions were in upper or lowercase, but now if i search for "product name" and the actual product name is "PRODUCT NAME" opencart will return no results.

Is there anyway of ignoring the case?

Re: Case sensitive search results?

Posted: Wed Oct 15, 2014 2:30 am
by unknownmale1
As an update, this was caused by importing data from an earlier version of OC. Post v1.5 uses utf8_ci.

Updating the collation in my database resolved the issue.

Re: Case sensitive search results?

Posted: Mon Feb 09, 2015 5:26 am
by pollux
I had the same issue when i upgraded recently from to Changing the collation of database to utf8_general_ci wasn't sufficient. I've had to change the collation of 'model' field of 'product' table and description,meta_description,meta_keyword,tag fields of 'product_description' table. Both utf8_general_ci.
Everything works perfect now.
Hope this will helps .

Re: Case sensitive search results?

Posted: Tue Mar 31, 2015 1:13 am
by exit15
this is rather frustrating. I also have -- Spent 10 minutes with a customer who was looking at a product page "ProEcza" and I couldn't find it because i typed "Proecza" or "proecza".

Anyway i tried to change to utf8_general_ci - no change in the results.
Any thoughts? It seems to be working for the p.model which doesn't care about the case.
Do i need to restart mysql? thanks ex

Re: Case sensitive search results?

Posted: Tue Mar 31, 2015 1:39 am
by exit15
UPDATE! apparently the change did not take root due to Error 1283 "Column 'description' cannot be part of FULLTEXT index". I had to change both name and description field to utf8_general_ci and now the search is no longer case sensitive.

I am guessing that this failed during the upgrade from an earlier version and I did not notice any errors.

People test your search if you are not getting results due to case sensitive search the solution is to alter both name and description fields in the product_description table to utf8_general_ci -- good luck! ex