Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

search result without special letter ex. ą,ł, ź, ż etc.


driven22

Recommended Posts

 
I have a problem with searching in the store. When I type a word with a special letter, e.g. łopian, it shows that there is no such product. If I type opian finds the product. This is probably a SQL encoding problem:
 
My sql :

Variable_name
Value  
character_set_client utf8mb4
character_set_connection utf8
character_set_database latin2
character_set_filesystem binary
character_set_results utf8mb4
character_set_server latin2
character_set_system utf8
character_sets_dir /home/mysql101/share/mysql/charsets/

Variable_name
Value  
collation_connection utf8_unicode_ci
collation_database latin2_general_ci
collation_server latin2_general_ci
Link to comment
Share on other sites

Maybe someone will be useful , about 630 line in general php:
 

////
// Parse search string into indivual objects
 // function tep_parse_search_string($search_str = '', &$objects) {
 //   $search_str = trim(strtolower($search_str));
 
 //wyniki wyszukiwania z polskimi literami
 
   function tep_parse_search_string($search_str = '', &$objects) {
       $search_str = trim($search_str);
       $search_str = mb_convert_case($search_str, MB_CASE_LOWER, "utf-8");

Best regards
Grzesiek

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...