As any user (logged in or guest) visit the main dance search page (i.e. https://contradb.com/ ).
Select to include "not verified" dances in the search filter (as of writing, the only dances titled with leading whitespace are unverified).
Increase "Results per page" to 30 (so we can see both affected and unaffected rows).
Click the "Title" column heading to sort it A-Z.
Actual results
Some dances with titles appearing to start with various letters are sorted to the top of the list, out of A-Z lexical order. Upon inspection, the out-of-order dances have a leading space character.
Expected results
The titles are sorted in a lexical order that corresponds to their rendered title, disregarding any leading whitespace.
Notes
Not having thought very thoroughly on it, I would advocate for trimming titles before persisting (and retroactively trimming already-persisted titles).
Steps to reproduce
Actual results
Some dances with titles appearing to start with various letters are sorted to the top of the list, out of A-Z lexical order. Upon inspection, the out-of-order dances have a leading space character.
Expected results
The titles are sorted in a lexical order that corresponds to their rendered title, disregarding any leading whitespace.
Notes
Not having thought very thoroughly on it, I would advocate for trimming titles before persisting (and retroactively trimming already-persisted titles).