Opencart区分大小写搜索? [关闭]

I'm using Opencart Version 1.5.6.4 and the search results appear to be case sensitive?

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?

This has been resolved.

I had updated from a previous version of opencart and imported product information (UTF8_Bin). Since 1.5 the database has been switched to utf8_general_ci collation so text matching in queries is no longer case sensitive.

Just updated the database collation to utf8_general_ci. Issue resolved.