Open
Description
On the Individual Members page and in the Django admin, the sorting of the names seems to ignore spaces. This leads to surprising results when people share a first name (or close), for example:
- Tim Allen
- Tim Baxter
- Tim Graham
- Tim Kamanin
- Timo Zimmermann
- Tim Schilling
I would have expected Timo to either be at the start or (most likely) end of that list, not in the middle.
Investigating with @ontowhee, we suspect it’s a matter of how collation is set up (the SQL for the ordering is just ORDER BY "members_individualmember"."name" ASC
). Not sure if we want to change the collation on the field with db_collation
, or for this specific query.