Source menu should be ordered somehow

[annamorphism]

The edit-sequence page allows the assignment of chants to a source in the database, but the dropdown is not in any kind of order, so it's hard to find the right one:

We don't really expect to have to do this after the Bower data is cleaned up, so it's not a priority, but it would make the cleaning up easier...

[dchiller]

Agreed. I think this is something we will get to in the broader overhaul of segments and projects ... I'm not sure exactly how, but it will definitely be different/better than this.

[annamorphism]

wait, they are ordered, just by the city, with special characters at the end of the alphabet (which happened to be where I looked first). So not quite as bad as I thought...

[ahankinson]

It’s quite obviously because Unicode code points for non-Latin characters are outside of the range 0-127 and thus their numeric value is higher, and OBVIOUSLY when sorting text you want to sort by the numerical code point and not by their lexical value.

Says every database ever.

This is computing law that was written in the 1960s when every character of storage cost the same as a new car, and must never be changed

(Yes, it’s dumb)

[annamorphism]

(Yes, it’s dumb)

speaking from personal experience with lowercase "d" falling after uppercase Z...agreed.