Thread:Project:Support desk/Search function in File list doesn't work properly/reply

I've always thought the File List search needed some sort of option to activate since it never worked for me.

Checking the file, the query generated attempts to convert both the image names and the search query to lowercase before using a LIKE comparison. I've checked the database and apparently the image name column is set as VARBINARY, preventing the lowercase conversion of the image name thus botching the comparison.

TL;DR Go to includes\specials\SpecialListfiles.php. On Line 84, change: $this->mQueryConds[] = 'LOWER(img_name)'. to $this->mQueryConds[] = 'CONVERT(img_name USING latin1)'.

Necrobumping since this problem still persists in 1.19.

kthxbye.