OpenCart Community

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

In catalog/model/catalog/product.php file,

replace:
with:

What's TRIMming '% some term %' going to do? Does TRIM work inside a string, or just leading and trailing blanks (which don't exist here)? Did you mean to trim the search term before wrapping %'s around it?

MrPhil wrote: ↑

Sat Nov 25, 2017 1:01 am

What's TRIMming '% some term %' going to do? Does TRIM work inside a string, or just leading and trailing blanks (which don't exist here)? Did you mean to trim the search term before wrapping %'s around it?

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.

search in categories and result show ?

can you help me ?

thank you

Which OC version?

2.1.0.2
thank you thank you

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".

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.

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.

how to search in sub categories ?

saliverdim wrote: ↑

Tue Jan 02, 2018 9:01 am

how to search in sub categories ?

This extension may be useful: https://www.opencart.com/index.php?rout ... n_id=12145

please help me ?

search : pınar aylin found.
search : pinar aylin not found :/

serch : hakkı found
search : hakki not found

can you help me ?

2.0.1.2
jorunal

straightlight wrote: ↑

Thu Nov 30, 2017 4:30 am

Let's troubleshoot this issue regarding accentuated characters. In system/helper/utf8.php file, at the bottom of fhe file,

find:

Code: Select all

return $string;
	}

replace with:

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);
}

Then, in your catalog/model/catalog/product.php file,

find all instances of:

Code: Select all

$implode[] = "pd.name LIKE '%" . $this->db->escape($word) . "%'";

replace all with:

Code: Select all

$implode[] = "pd.name LIKE '%" . $this->db->escape(replaceAccents($word, $this->session->data['language'])) . "%'";

Then, find all instances of:

Code: Select all

$sql .= " OR pd.description LIKE '%" . $this->db->escape($data['filter_name']) . "%'";

replace all with:

Code: Select all

$sql .= " OR pd.description LIKE '%" . $this->db->escape(replaceAccents($data['filter_name'], $this->session->data['language'])) . "%'";

See if that solves the issue.

thank you but, 1.steps after website not working (

and very very hard.

another fix ?

ı use ısearchcortable but same problem (

ı try 2 years

2.0.1.2

This is probably a database encoding issue, not an OpenCart code issue. Make sure your database is set to have a collation of "utf8_unicode_ci", so that it works with non-English characters, and can see them as the equivalent English character when entered. If it's not, here's the database query you'd run to change that collation:


Make sure you replace "oc_" with your database prefix.

Johnathan wrote: ↑

Tue Aug 14, 2018 9:44 pm

This is probably a database encoding issue, not an OpenCart code issue. Make sure your database is set to have a collation of "utf8_unicode_ci", so that it works with non-English characters, and can see them as the equivalent English character when entered. If it's not, here's the database query you'd run to change that collation:

Code: Select all

ALTER TABLE oc_product_description CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Make sure you replace "oc_" with your database prefix.

hi again,
ı use utf8 general_ci
I tried convert your code but now he does not find anything. (

If utf8_unicode_ci doesn't work, then switch back to utf8_general_ci. However, the database encoding is still likely the issue, so you should look into that, or hire someone with more experience to look into it for you. You may have other database encoding issues going on, which could be causing conflicts.

Johnathan wrote: ↑

Thu Aug 16, 2018 5:22 am

If utf8_unicode_ci doesn't work, then switch back to utf8_general_ci. However, the database encoding is still likely the issue, so you should look into that, or hire someone with more experience to look into it for you. You may have other database encoding issues going on, which could be causing conflicts.

thank you but I think the problem is in OpenCart itself.because i looked with isenslab isearchcortable extentions and ı tryed ı = i and worked.but this does not work for me.because this time i can not find the letters "i" :/

Updated instructions from my previous post.

Replace:
with:
to search LONGBLOB field types. Looks for case sensitive but not accent sensitive: https://stackoverflow.com/questions/500 ... h-in-mysql

straightlight wrote: ↑

Thu Aug 16, 2018 6:21 am

Updated instructions from my previous post.

Replace:

Code: Select all

$implode[] = "pd.name LIKE TRIM(LCASE('%" . $this->db->escape($word) . "%'))";

with:

Code: Select all

$implode[] = "pd.name LIKE TRIM(LCASE('%" . $this->db->escape($word) . "%')) COLLATE utf8_general_ci";

to search LONGBLOB field types. Looks for case sensitive but not accent sensitive: https://stackoverflow.com/questions/500 ... h-in-mysql

thank you but, 1.steps after website not working ( first for you message..
and after ı tryed only here your message but problem not resolve

catalog/model/catalog/product file : https://we.tl/Kz2PNHcCMq
catalog/model/catalog/isearch file : https://we.tl/Kz2PNHcCMq


I need :
i = ı and ı = i
and
lower case sameone in search.
please (