Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second group tends works in shops that leave everything on default.  A huge portion of my career has been spent as a member of that “Custom collation? What custom collation?” crowd, and ...