Filtering pages by their tags - it's case sensitive

Bug #788444 reported by Szilvia Toth on 2011-05-26
This bug affects 1 person
Affects Status Importance Assigned to Milestone

Bug Description

Environment: 1.4

User can filter pages by their tags but it's case sensitive. It depends how user enters tag on the Edit Title and Description page (using lower or upper case).

Changed in mahara:
importance: Undecided → Medium
status: New → Triaged
tags: added: tags
Changed in mahara:
assignee: nobody → Hugh Davenport (hugh-catalyst)
status: Triaged → In Progress
Hugh Davenport (hugh-davenport) wrote :
Changed in mahara:
status: In Progress → Opinion
François Marier (fmarier) wrote :

I think that we should probably fix it (a status of "opinion" means "wontfix"), but I'm not entirely sure how yet.

Perhaps a good first step would be to lowercase all new tags entered by users.

Changed in mahara:
status: Opinion → Triaged
importance: Medium → Low
assignee: Hugh Davenport (hugh-catalyst) → nobody

In postgres it wouldn't be a big problem to leave the contents of the db alone, we could just add an index on LOWER(tag) and lowercase the search terms. But for mysql the easiest way would be to do what Hugh did in that patch - basically destroy data by lowercasing everything in the tag column (removing dupes first to avoid the pk error). Anther option would be creating a new indexed column and putting the lowercased tags in there.

Robert Lyon (robertl-9) wrote :

The discussion here relates to this bug also:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers