Searching problem - capitalised titles

[steveo222]

Hi, hope someone can help. :blink:

 

I've been searching all day for an answer to this but to no avail.

I am using a fresh install of osCommerce. The problem is when I have a product with capitialised titles e.g. Metal bracelet.

If I do a search for metal or even Metal, it returns no results. However if I search for bracelet, it returns the correct product. Changing the title to metal bracelet will sort out the problem, but doesn't look pretty. Is osCommerce's search system case sensitive? If it is, then in the above example it should at least return something if I search for Metal ?

 

Thanks for your help!

-Steve

[steveo222]

Just posting a reply to my own question.

The problem I had was due to the way I set up the mySQL database. Before, I had the collation type set to utf8_bin (doh!) which is case sensitive. Changing it to utf8_unicode_ci solved the problem. Hope this helps someone who's just started out with osCommerce like me...

 

Cheers

-steve