are you mad because the collation is case insensitive?

Yes.
using case insensitive is nuts.![]()


Yes.
I should have paid more attention to default collations - using case insensitive is nuts.![]()
Why do you want case sensitivity?
In EVERY system I've worked on having a case sensitive database would have been a nightmare

defaults in my view should not have such sneaky side effects: this effectively forces to use explicit collation in SQL, leading to dirty code.
Default collation is set at instance level and can easily be determined during install.