User search is case sensitive

Interesting that your profile search is case sensitive (the patch makes sense for that), because I can search in all different cases, even mixed, and still see the correct expected results. Remember, the user has to have something in at least one of the profile fields for that user to show up in the search results.

No reply on this issue, and I can't replicate it, so marking as fixed.

Hi

I can reproduce this on my system. I'm using drupal 6.14 Profile Plus 6.x-1.1 and Postgres 8.1.5. LIKE is case sensitive in Postgres: http://www.postgresql.org/docs/8.1/static/functions-matching.html.

The following works for me:

$sql = "FROM {users} u INNER JOIN {profile_values} pv ON u.uid = pv.uid INNER JOIN {profile_fields} pf ON pv.fid = pf.fid WHERE LOWER(pv.value) LIKE LOWER('%%%s%%') OR LOWER(u.name) LIKE LOWER('%%%s%%')";

Fixed in substantial rewrite of profile_search() function in 6.x-2.x-dev version.

James