Bug #83539

Backend live search doesn't find text with umlauts

Added by Sven Burkert 8 months ago. Updated 7 months ago.

Status:
Resolved
Priority:
Must have
Assignee:
-
Category:
-
Target version:
-
Start date:
2018-01-11
Due date:
% Done:

100%

TYPO3 Version:
8
PHP Version:
7.0
Tags:
search, live search, ajax search, backend search, umlaut, umlauts
Complexity:
Is Regression:
Sprint Focus:

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.

Associated revisions

Revision f3d273d6 (diff)
Added by Sven Burkert 7 months ago

[BUGFIX] Allow multi-byte characters in live search

Resolves: #83539
Releases: master, 8.7
Change-Id: I4d589d0654ab7ee091b664957fbb8c6d101be663
Reviewed-on: https://review.typo3.org/55997
Reviewed-by: Markus Klein <>
Tested-by: TYPO3com <>
Reviewed-by: Guido Schmechel <>
Tested-by: Guido Schmechel <>
Reviewed-by: Andreas Fernandez <>
Reviewed-by: Mathias Schreiber <>
Tested-by: Mathias Schreiber <>
Reviewed-by: Wouter Wolters <>
Tested-by: Wouter Wolters <>

Revision 954baccd (diff)
Added by Sven Burkert 7 months ago

[BUGFIX] Allow multi-byte characters in live search

Resolves: #83539
Releases: master, 8.7
Change-Id: I4d589d0654ab7ee091b664957fbb8c6d101be663
Reviewed-on: https://review.typo3.org/56008
Reviewed-by: Michael Oehlhof <>
Tested-by: TYPO3com <>
Reviewed-by: Wouter Wolters <>
Tested-by: Wouter Wolters <>

History

#1 Updated by Reiner Teubner 8 months ago

On version 8.7.9 looks all fine. All my test cases where found with the search module on top right.

#2 Updated by Georg Ringer 8 months ago

  • Status changed from New to Needs Feedback

#3 Updated by Sven Burkert 8 months ago

Ok, sorry. Problem just exists on my localhost. In same TYPO3 system, but different server, search works.

#4 Updated by Riccardo De Contardi 8 months ago

@Sven Burkert thank you for your quick answer; so do you think that this issue can be closed?

#5 Updated by Sven Burkert 8 months 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.

#6 Updated by Riccardo De Contardi 8 months 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?

#7 Updated by Sven Burkert 8 months 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".

#8 Updated by Riccardo De Contardi 8 months ago

  • Status changed from Needs Feedback to New

I was able to reproduce it! Me too on Windows 7,[SYS][systemLocale] not set.

#9 Updated by Gerrit Code Review 7 months 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

#10 Updated by Gerrit Code Review 7 months 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

#11 Updated by Sven Burkert 7 months ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100

Also available in: Atom PDF