Bug #83539
closedBackend live search doesn't find text with umlauts
100%
Description
When using the ajax live search on top right and searching for text containing umlauts (e.g. ä, ö, ß), nothing is found.
The search in list module is working as expected, the contents with umlauts are found.
Updated by Reiner Teubner almost 7 years ago
On version 8.7.9 looks all fine. All my test cases where found with the search module on top right.
Updated by Georg Ringer almost 7 years ago
- Status changed from New to Needs Feedback
Updated by Sven Burkert almost 7 years ago
Ok, sorry. Problem just exists on my localhost. In same TYPO3 system, but different server, search works.
Updated by Riccardo De Contardi almost 7 years ago
@Sven Burkert thank you for your quick answer; so do you think that this issue can be closed?
Updated by Sven Burkert almost 7 years ago
It's still strange and perhaps a TYPO3 bug, that live search on top right doesn't work with umlauts on my localhost and search in list module does, but if you think, it's the fault of my localhost, please close this ticket.
Updated by Riccardo De Contardi almost 7 years ago
@Sven Burkert could you add more information on how to reproduce your issue? Please add as much info as possible about your localhost system and configuration.
It is hard to decide wether it is an actual bug or a local misconfiguration; I have tried a little test on my local machine
- TYPO3 8.7.9
- MAMP environment
- PHP 7.1.8
- MySQL 5.6.35
- utf8_general_ci database collation
I created a page whose title contain the letters "ä, ö, ß" and a page content with the same letter and the upper right corner search was able to find both.
Should I perform a different test?
Updated by Sven Burkert almost 7 years ago
I've broken it down to line 366 in file typo3/sysext/backend/Classes/Search/LiveSearch/LiveSearch.php:
$queryBuilder->createNamedParameter(strtolower($like), \PDO::PARAM_STR)
Parameter "$like" is here e.g. "%testä%", but "strtolower($like)" results in "%test�%".
When using function "mb_strtolower" live search works.
$GLOBALS['TYPO3_CONF_VARS']['SYS']['systemLocale'] is not set, OS is Windows 7, locale for LC_CTYPE is "German_Germany.1252".
Updated by Riccardo De Contardi almost 7 years ago
- Status changed from Needs Feedback to New
I was able to reproduce it! Me too on Windows 7,[SYS][systemLocale] not set.
Updated by Gerrit Code Review over 6 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/55997
Updated by Gerrit Code Review over 6 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/56008
Updated by Sven Burkert over 6 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset f3d273d67ed80768f64c3d85ad1ff88ccf32140a.