FL0RIAN Posted November 18, 2014 Posted November 18, 2014 If a user searches (frontend) for words with german umlauts like ä, ö, etc. no results are given back. Do you have any solution? Thanks.
Mats Posted November 18, 2014 Posted November 18, 2014 Try changing the collation in PHPMyAdmin for the fields you wan't to search (or all for that matter). SO link
mjut Posted September 20, 2023 Posted September 20, 2023 I am experiencing the same issue – changing the collation did not fix it. But maybe it is something different? When searching for Lüneburg the word is being found in all body-fields (textarea) but not in title-fields (the system generated text field). Replacing the Ü with U, I'll get the desired results. Here comes the weird behavior: When searching vor üneburg (umlaut it the beginning of the word) all results with "Lüneburg" in the title-field are being found and listed!!! Isnt that weird? I did look into the database: all tables are set to utf8_general_ci. Changing them to utf8_unicode_ci or even utf8mb4_unicode_ci did not change a thing. I am not sure, where to look into next?
mjut Posted September 25, 2023 Posted September 25, 2023 Alright. It wasn't a MySQL-issue at all! In my search-template I've been using the selector fields incorrectly. I wanted a page-referenece field to be searched and listed. in the selectors I called "pagereference" what I need to do was putting "pagereference.title" into the selectors! Without putting *title after the field, the results were based on searching the url. That led to results I wasnt expecting...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now