Enable providers to change type mapping characteristics based on collation

[ajcvickers]

For example, to do case-sensitive verses in-sensitive comparisons--see #32898

Related to #29620

[roji]

@ajcvickers this would mean understanding whether a given e.g. SQL Server collation is case-sensitive or not, right?

[ajcvickers]

@roji Yep. In the meeting, Andriy indicated this is what we should do. I'm somewhat on the fence.

[AndriySvyryd]

Setting a case sensitive collation on the model would be a shortcut to configure all default key comparisons.