Case sensitive sreach

Hi,
I notice that search is case sensitive. If in description of the products there is a word "Good" and i run a search for word "good", the search return zero results, but if i type "Good" the search results contains all products with this word.
How i can make this search to be not case sensitive?
Thank you in advance

Any suggestions?

Hey there. I ran into the same problem. Did a little searching through the php files and found one that needed a few lines code altered. Here is the file and the location:

includes/modules/pages/advanced_search_result/header_php.php

Obviously, back up your file before making this change.

I changed mainly two things. First I convert the string of text entered by the user to lower case. Next I convert all of the database fields being searched to lower case. That's it. Here is a block of code where the changes are. It starts around line 292.

copy code from below here ====================

if (isset($keywords) && zen_not_null($keywords)) {
if (zen_parse_search_string(stripslashes($_GET['keyword']), $search_keywords)) {

	$keywords = strtolower($keywords);
	
	$where_str .= " AND (";
for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) {
  switch ($search_keywords[$i]) {
    case '(':
    case ')':
    case 'and':
    case 'or':
    $where_str .= " " . $search_keywords[$i] . " ";
    break;
    default:
    $where_str .= "(lower(pd.products_name) LIKE '%:keywords%'
                                     OR lower(p.products_model)
                                     LIKE '%:keywords%'
                                     OR lower(m.manufacturers_name)
                                     LIKE '%:keywords%'";

    $where_str = $db->bindVars($where_str, ':keywords', $search_keywords[$i], 'noquotestring');
    // search meta tags
    $where_str .= " OR (lower(mtpd.metatags_keywords)
                    LIKE '%:keywords%'
                    AND mtpd.metatags_keywords !='')";

    $where_str = $db->bindVars($where_str, ':keywords', $search_keywords[$i], 'noquotestring');

    $where_str .= " OR (lower(mtpd.metatags_description)
                    LIKE '%:keywords%'
                    AND mtpd.metatags_description !='')";

copy code from above here ========================

Hope that helps. I'm glad I could finally make a contribution. This forum has helped me many times.

• Michael Stein

Remember that strtolower() is only reliable with latin language encoding. It does not work with multibyte language charactersets.

DrByte:

Remember that strtolower() is only reliable with latin language encoding. It does not work with multibyte language charactersets.

Then what should I do if I have the same problem but with unicode characters? Actually, the problem is not quite the same: my search is working fine (it is not case-sensitive) with simple characters, but the special Hungarian vowels seem to be case-sensitive.

E.g. both *pir *and *Pir *work for *piros *but
*űrk *does not work for *Űrkutatás *

I'm using v1.3.9h, and I just can't figure this out..

Any suggestions?

Thanks in advance!