1-pinpon
2-pınpon
I search pinpon , result 1
I search pınpon , result 1
must result all
2.1.0.2 journal
I have 2 product
1-pinpon
2-pınpon
I search pinpon , result 1
I search pınpon , result 1
must result all
2.1.0.2 journal
1-pinpon
2-pınpon
I search pinpon , result 1
I search pınpon , result 1
must result all
2.1.0.2 journal
In catalog/model/catalog/product.php file,
replace:
with:
replace:
Code: Select all
$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";
Code: Select all
$implode[] = "pd.name LIKE TRIM(LCASE('%" . $this->db->escape($word) . "%'))";
The most generated errors being found on Opencart forum originates from contributed programming.
Regards,
Straightlight
Be reminded that both %, one at the beginning and one at the end, are being used on this query which means that anything from the beginning and the end can be matched. Which is why, trim is implicit with this string search.
The most generated errors being found on Opencart forum originates from contributed programming.
Regards,
Straightlight
Which OC version?
The most generated errors being found on Opencart forum originates from contributed programming.
Regards,
Straightlight
Something I didn't notice before: one is a regular "i", and the other is a "dotless i". Is there a reason for the difference? Was it deliberate? Changing the dotless i to a regular ASCII i might solve the problem, if it was accidental. Otherwise, a regular i and a dotless i won't match in a search. If you want to keep the dotless i, take a look at the page and database encoding -- dotless i is in Unicode Latin Extended-A, and not normally found in a Latin-x code page (at least, not Latin-1). It might have snuck in through Windows CP-125x, around x9D or so ("smart quotes"). Still, I don't see how one can expect the search to return both of them.
Possibly, your database can be configured to treat "i" and "dotless i" the same in searches, but I don't know how to do it. It would probably be something in the selected "collation".
Possibly, your database can be configured to treat "i" and "dotless i" the same in searches, but I don't know how to do it. It would probably be something in the selected "collation".
Let's troubleshoot this issue regarding accentuated characters. In system/helper/utf8.php file, at the bottom of fhe file,
find:
replace with:
Then, in your catalog/model/catalog/product.php file,
find all instances of:
replace all with:
Then, find all instances of:
replace all with:
See if that solves the issue.
find:
Code: Select all
return $string;
}
Code: Select all
return $string;
}
function removeAccents($value, $language) {
$code = explode('-', trim($language));
setlocale(LC_ALL, strtolower($code[0]) . "_" . strtoupper($code[1]) . ".utf8");
return iconv('UTF-8', 'ASCII//TRANSLIT',$value);
}
find all instances of:
Code: Select all
$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";
Code: Select all
$implode[] = "pd.name LIKE '%" . $this->db->escape(replaceAccents($word, $this->session->data['language'])) . "%'";
Code: Select all
$sql .= " OR pd.description LIKE '%" . $this->db->escape($data['filter_name']) . "%'";
Code: Select all
$sql .= " OR pd.description LIKE '%" . $this->db->escape(replaceAccents($data['filter_name'], $this->session->data['language'])) . "%'";
The most generated errors being found on Opencart forum originates from contributed programming.
Regards,
Straightlight
If you have any trouble with the iconv() code, be sure to read http://php.net/manual/en/function.iconv.php. The TRANSLIT may not be supported on all PHP installations, but if it is, it is supposed to transliterate characters to the nearest ASCII equivalent (e.g., ö/ö becomes oe). You should test that dotless i becomes a regular i. Since this is server-side, you don't have to worry about what browsers your customers are using, but if you're on a separate database server, that needs to be checked.
This extension may be useful: https://www.opencart.com/index.php?rout ... n_id=12145
The most generated errors being found on Opencart forum originates from contributed programming.
Regards,
Straightlight
Who is online
Users browsing this forum: No registered users and 9 guests
