Static entity changes should use a case-sensitive compare when creating data updates
393
Views
1
Comments
New
Database

When a static entity label is changed by case only (eg "Done" to "DONE", or "Date Of Birth" to "Date of Birth"), the label is not changed when data update scripts are created. Presumably this is because the database script to check for differences uses the COLLATION of the data which is not case sensitive.

This suggestion is to use a case sensitive compare when creating data update scripts for static entities.

I got the same issue recently and strongly support the idea, not only for labels, but custom static entities' attributes as well. I had to add extra symbols to values, publish and then remove them to update everything properly, and that makes no sense.