search

marxjohnson / moodle-block_quickfindlist

Moodle block providing a quick method of searching users
http://moodle.org/mod/data/view.php?d=13&rid=2200
6 stars 15 forks source link

support case-insensitive search #4

Closed abias closed 10 years ago

abias commented 12 years ago

Hi,

sorry for double-posting, but I don't know if you are subscribed to Moodle Tracker.

Please have a look at http://tracker.moodle.org/browse/CONTRIB-3569

Thanks in advance Alex

marxjohnson commented 12 years ago

Currently the block just uses your search term in an SQL LIKE statement. Case-insensitivity is supported in this way, if your user table uses a case-insensitive collation (e.g. utf8_general_ci). The same goes for https://github.com/marxjohnson/moodle-block_quickcourselist/issues/4, with regards to the course table.

I will look at a cross-database method of implementing this at application level.

abias commented 10 years ago

Solving case-insensitivity on the database-level solved the problem -> Closing the issue