Menu

#7 Fixed case sensitivity on search

open
nobody
None
5
2009-09-08
2009-09-08
Anonymous
No

Case insensitivity is fixed:

Was this:

$search .= "AND SUBSTRING_INDEX(filename, '.torrent',1) LIKE '%".$query."%'";

Now this:

$search .= "AND TRIM(TRAILING '.torrent' FROM filename) COLLATE latin1_swedish_ci LIKE '%".$query."%'";

Discussion


Log in to post a comment.

MongoDB Logo MongoDB