Project

General

Profile

Actions

Bug #83539

closed

Backend live search doesn't find text with umlauts

Added by Sven Burkert over 6 years ago. Updated over 5 years ago.

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

100%

Estimated time:
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.

Actions #1

Updated by Reiner Teubner over 6 years ago

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

Actions #2

Updated by Georg Ringer over 6 years ago

  • Status changed from New to Needs Feedback
Actions #3

Updated by Sven Burkert over 6 years ago

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

Actions #4

Updated by Riccardo De Contardi over 6 years ago

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

Actions #5

Updated by Sven Burkert over 6 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.

Actions #6

Updated by Riccardo De Contardi over 6 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?

Actions #7

Updated by Sven Burkert about 6 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".

Actions #8

Updated by Riccardo De Contardi about 6 years ago

  • Status changed from Needs Feedback to New

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

Actions #9

Updated by Gerrit Code Review about 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

Actions #10

Updated by Gerrit Code Review about 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

Actions #11

Updated by Sven Burkert about 6 years ago

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

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF