[germanier]

Actually I was a bit surprised when I learned that Unicode only added a codepoint for it in 2008 (and even rejected an earlier proposal). While the spelling rules have said for some time to replace it with "SS" the glyph was used quite often, including official documents such as passports.

For sorting there is standard (DIN 5007). Replacing ß with ss is correct (even in the lower case variant). The other letters are more fun: ä is replaced with a for sorting, except if you sort a list of names. In that case you need to replace it by ae. Probably not something international software is aware of. The Austrian sorting of names is different and other languages that have the same glyph (e.g. Swedish) also have other rules (e.g. by placing ä at the very end of the alphabet).

[Freak_NL]

> Probably not something international software is aware of.

Collation rules that vary by locale exist for this reason, and all major programming languages and OS'es support this. Of course whether the software you use does this or not depends on the developers writing the software.

[germanier]

Thanks for the term, I wasn't aware of it. This looks to be a standard problem in DBMSs at least. While not all of the rules I mentioned seem to be shipped by default, it looks fairly straightforward to add them. I just remember our development team moaning quite a bit after I added the requirement to sort names differently.

[matt4077]

Funny you mention Swedish. Let's all bond over the shared experience of "why tf is this using latin1_swedish_ci collation?"