Page MenuHomePhabricator

Special:ListFiles doesn't find anything when search term contains non-ascii characters
Closed, DuplicatePublic

Description

Special:ListFiles doesn't find anything if the search term contains german umlauts (the letters äöüÄÖÜß) - for example, searching for "Möhre" will give zero results, but I have files like "Möhre-Wilde-Blüte.jpg" and "Pfalz-Möhren-1.jpg".

This is a duplicate of T34207 where no patch was written, but a valid workaround exists (at least for REL1_31) and hopefully could be solved in the next REL1_35 release. Here the workaround (source https://www.mediawiki.org/wiki/Topic:Pwjch65m0lbr7n8e):

Edit the file includes/specials/pagers/ImageListPager.php and replace the line:

$conds[] = 'LOWER(' . $prefix . '_name)' .

with

$conds[] = 'CONVERT(' . $prefix . '_name USING utf8)' .

Event Timeline

taavi renamed this task from Special:Listfiles doesn't find anything when search term contains non-ascii characters to Special:ListFiles doesn't find anything when search term contains non-ascii characters.Jun 2 2020, 2:52 PM
taavi moved this task from To triage to Multimedia-related on the MediaWiki-Special-pages board.
taavi updated the task description. (Show Details)

If this is already reported as T34207 then no duplicate should be created, as that leads to conversation fragmentation. :)