{"id":5819,"date":"2020-10-26T04:13:27","date_gmt":"2020-10-26T04:13:27","guid":{"rendered":"https:\/\/litextension.com\/faq\/docs\/shopping-cart-questions\/prestashop\/search-is-not-working-in-any-other-language\/"},"modified":"2024-12-30T04:08:03","modified_gmt":"2024-12-30T04:08:03","slug":"search-is-not-working-in-any-other-language","status":"publish","type":"docs","link":"https:\/\/litextension.com\/faq\/docs\/migration-process\/common-migration-errors\/search-is-not-working-in-any-other-language\/","title":{"rendered":"Search is not working in any other language"},"content":{"rendered":"<p>Sometimes, when you have your eCommerce in multiple languages you can have this issue.<\/p>\n<p>The main problem when this happens is that\u00a0<strong>people can\u2019t find what they are looking for or they\u00a0<a href=\"https:\/\/www.doofinder.com\/en\/blog\/404-not-found-error?mktcod=OUTR&amp;utm_source=LPR\" target=\"_blank\" rel=\"noopener\">get a 404 error.<\/a><\/strong><\/p>\n<p>One of the most common problems that people have, is creating a database with the\u00a0<strong>wrong collation settings.<\/strong>\u00a0For example, if your language is Persian, and you don\u2019t have it well configured. This is because you have the wrong collation settings on your database.<\/p>\n<p>On almost every server the default collation is<strong>\u00a0Latin1<\/strong>, if you are using the wrong collation on your Database, you will get errors when importing data with wrong characters and this will affect your internal search results.<\/p>\n<p>If your shop is only in English you will not have problems, but as mentioned before\u00a0<strong>for all other languages<\/strong>\u00a0with special characters and accents (like Persian, Arabic\u2026) Not having the right collation on your database is a big problem. Special characters with accents will be changed with the wrong results.<\/p>\n<p>If you want to run away from this issue you need to make sure your collation is:\u00a0<strong>utf8_general_ci<\/strong><\/p>\n<div id=\"eJOY__extension_root\" class=\"eJOY__extension_root_class\" style=\"all: unset;\"><\/div>\n","protected":false},"author":1,"featured_media":0,"parent":6779,"menu_order":18,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_tag":[],"class_list":["post-5819","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/5819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/comments?post=5819"}],"version-history":[{"count":1,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/5819\/revisions"}],"predecessor-version":[{"id":5820,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/5819\/revisions\/5820"}],"up":[{"embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/6779"}],"next":[{"title":"Images are not shown on frontend after migration","link":"https:\/\/litextension.com\/faq\/docs\/migration-process\/common-migration-errors\/images-are-not-shown-on-frontend-after-migration-what-should-i-do\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/1537"}],"prev":[{"title":"LitExtension can\u2019t connect to my Cloudflare site. What should I do?","link":"https:\/\/litextension.com\/faq\/docs\/migration-process\/common-migration-errors\/litextension-cant-connect-to-my-cloudflare-site-what-should-i-do\/","href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/docs\/7384"}],"wp:attachment":[{"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/media?parent=5819"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/litextension.com\/faq\/wp-json\/wp\/v2\/doc_tag?post=5819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}