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
Andrew Allen
shared this idea
-
Arneh Eskandari
commented
Add the option to Force binary collation for static data