Pay attention to case changes in static data tables even if case insensitive collation used
SQL Source Control will not notice case-only changes to data if the column has a Case Insensitive collation (which is the default out-of-the-box for most SQL Server installations). This bit me when I needed to "sentence case" some "ALL CAPS" data but SQL Source Control didn't even notice until I forced the collation on these columns to be SQLLatin1GeneralCP1CS_AS, which seems unnecessary. Maybe a per-table static data option?
44
votes
![](https://secure.gravatar.com/avatar/70799a9bb9b9a8ec319c2ed7efbdd8b5?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Arneh Eskandari commented
Add the option to Force binary collation for static data