driven22 Posted March 25, 2020 Share Posted March 25, 2020 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 More sharing options...
driven22 Posted April 1, 2020 Author Share Posted April 1, 2020 Solved by add code in general.php Link to comment Share on other sites More sharing options...
driven22 Posted April 2, 2020 Author Share Posted April 2, 2020 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.